bing
Flat 10% & upto 50% off + 10% Cashback + Free additional Courses. Hurry up
×
UPTO
50%
OFF!
Intellipaat
Intellipaat

Select Distinct in SQL – Remove duplicate data from table

Select Distinct in SQL is used to remove the duplicate data from the table. SQL DISTINCT Keyword is used along with the SELECT statement

The SQL Distinct syntax is as follows:

SELECT DISTINCT column1, column2….

FROM table_name

WHERE [condition];

Example:

Consider the Student_details table:

NameRoll No.Marks
Akshay157
Charu268
Disha352
Eva468

Now we want to see the marks of the students and duplicate values will no display.

SELECT DISTINCT Marks

FROM Student_details

ORDER BY Marks;
Marks
52
57
68

Previous Next

Download Interview Questions asked by top MNCs in 2019?

"0 Responses on Select Distinct in SQL"

    100% Secure Payments. All major credit & debit cards accepted Or Pay by Paypal.
    top

    Sales Offer

    Sign Up or Login to view the Free Select Distinct in SQL.