bing
Flat 10% & upto 50% off + 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

  • To avail this offer, enroll before 22nd October 2017.
  • This offer cannot be combined with any other offer.
  • This offer is valid on selected courses only.
  • Please use coupon codes mentioned below to avail the offer
Learn offer banner( Diwali)

Sign Up or Login to view the Free DISTINCT.