SELECT DISTINCT in MySQL

SELECT DISTINCT

SELECT DISTINCT class FROM students;

DISTINCT on Multiple Columns

SELECT DISTINCT class, section FROM students;

Returns unique class+section combinations.

Summary

• DISTINCT shows unique values only.
• With multiple columns, the whole combination must be unique.

SELECT DISTINCT

SELECT DISTINCT class FROM students;

कई Columns पर DISTINCT

SELECT DISTINCT class, section FROM students;

Unique class+section combinations लौटाता है।

सारांश

• DISTINCT सिर्फ unique values दिखाता है।
• कई columns के साथ, पूरा combination unique होना चाहिए।