bing
Flat 10% & upto 50% off + Free additional Courses. Hurry up!

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"

Training in Cities

Bangalore, Hyderabad, Chennai, Delhi, Kolkata, UK, London, Chicago, San Francisco, Dallas, Washington, New York, Orlando, Boston

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

top

Sales Offer

  • To avail this offer, enroll before 05th December 2016.
  • 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
offer-june

Sign Up or Login to view the Free DISTINCT.