Select Distinct in SQL

500% salary hike received by a working professional post completion of the course*

Fresher earned 30 LPA salary package on completion of the course*

53% of learners received 50% and above salary hike post completion of the program*

85% of the learners achieved their training objectives within 9 months of course completion*

95% learner satisfaction score post completion of the program/training*

Process Advisors

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

SELECT DISTINCT column1, column2….
FROM table_name
WHERE [condition];

Example:
Consider the Student_details table:

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

Previous Next

Course Schedule