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

Leave a Reply

Your email address will not be published. Required fields are marked *