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

DISTINCT

 

It is used to remove the duplicate data from the table. DISTINCT Keyword is used along with the SELECT statement. The syntax is as follows:

Syntax:

SELECT DISTINCT column1, column2….

FROM table_name

WHERE [condition];

Example:

Consider the Student_details table:

Name Roll No. Marks
Akshay 1 57
Charu 2 68
Disha 3 52
Eva 4 68

 

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

"0 Responses on DISTINCT"

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

Sales Offer

OFFER DISCOUNT

Sign Up or Login to view the Free DISTINCT.