MySQL DISTINCT

A column often has the same value in many rows. SELECT DISTINCT returns each value only once.

SELECT city FROM students;

SELECT DISTINCT city FROM students;

---

Count unique values

SELECT COUNT(DISTINCT city) AS cities FROM students;

---

DISTINCT with more columns

With more than one column, DISTINCT looks at the combination.

SELECT DISTINCT city, course_id FROM students ORDER BY city;

Delhi appears twice because the two Delhi students have different course values (1 and NULL). Both Mumbai students have course 2, so Mumbai appears once.

---

Summary

• SELECT DISTINCT column removes duplicates.
• COUNT(DISTINCT column) counts the unique values.
• Next: LIKE and wildcards.

• Previous Page
• Next Page

---

Exercises & Assignments
No Content Found.

Interview Questions & Answers
No Content Found.