SQL Tutorial: 6

By alexxk5111

SQL DISTINCT – SQL Tutorial

The SQL DISTINCT clause is used together with the SQL SELECT keyword, to return a dataset with unique entries for certain database table column.

We will use our Customers database table to illustrate the usage of SQL DISTINCT.

FirstNameLastNameEmailDOBPhone
JohnSmith[email protected]2/4/1968626 222-2222
StevenGoldfish[email protected]4/4/1974323 455-4545
PaulaBrown[email protected]5/24/1978416 323-3232
JamesSmith[email protected]20/10/1980416 323-8888

For example if we want to select all distinct surnames from our Customers table, we will use the following SQL DISTINCT statement:


SELECT DISTINCT LastName
FROM Customers

The result of the SQL DISTINCT expression above will look like this:

LastName
Smith
Goldfish
Brown