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.

Syntax:

SELECT DISTINCT column1, column2,.....columnN 
FROM table_name
WHERE [condition]

Example:

Consider a Student record:

SELECT DISTINCT Country FROM Students;

The above query will return the Distinct country names.

Output:

Note: there’s a single America because we used the DISTINCT keyword.

Note: also read about SQL: HAVING Clause

Follow Me

Please follow me to read my latest post on programming and technology if you like my post.

https://www.instagram.com/coderz.py/

https://www.facebook.com/coderz.py

Rabecca Fatima

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.