What is the SQL DISTINCT keyword?
- The SQL DISTINCT keyword is used in conjunction with the SELECT statement to remove all duplicate records and only return unique records.
- DISTINCT can also be used in conjunction with aggregate SQL functions such as COUNT, MAX, SUM, AVG, and so on.
- DISTINCT operates not only on a single column of a table but also on multiple columns of a table, with DISTINCT in SQL eliminating rows where all the selected columns are identical.
SELECT DISTINCT column1, column2,.....columnN FROM table_name WHERE [condition]
Consider a Student record:
SELECT DISTINCT Country FROM Students;
The above query will return the Distinct country names.
Note: there’s a single America because we used the DISTINCT keyword.
Note: also read about SQL: HAVING Clause
Please follow me to read my latest post on programming and technology if you like my post.
Staying up to the mark is what defines me. Hi all! I’m Rabecca Fatima a keen learner, great enthusiast, ready to take new challenges as stepping stones towards flying colors.