SQL SELECT DISTINCT Statement

In this tutorial, you'll learn about the SQL DISTINCT clause and how to use it with the help of various examples.

The SQL SELECT DISTINCT statement selects unique rows from a database table. For example,

SELECT DISTINCT country
FROM Customers;

Here, the SQL command selects unique countries from the Customers table.

The DISTINCT clause with SELECT in SQL returns unique rows only
Example: Selecting unique countries

Let's see another example.

SELECT DISTINCT country, first_name
FROM Customers;

Here, the SQL command selects rows if the combination of country and first_name is unique.

The DISTINCT clause with two columns returns unique data by combining two rows
Example: Selecting the unique combined fields

DISTINCT with COUNT

If we need to count the number of unique rows, we can use the COUNT() function with DISTINCT.

SELECT COUNT(DISTINCT country)
FROM Customers;

Here, the SQL command returns the count of unique countries.

DISTINCT and COUNT used together to count unique values
Example: Counting unique countries

To learn more, visit SQL COUNT().


More SQL DISTINCT Examples

DISTINCT Vs GROUP BY

Let's take a look at an example,

-- with distinct
SELECT DISTINCT country
FROM Customers;

-- with group by
SELECT country
FROM Customers
GROUP BY country;

Here, both of the SQL commands are similar and return unique countries from the Customers table.

To learn more, visit SQL GROUP BY.

DISTINCT With ORDER BY

Let's take a look at an example,

SELECT DISTINCT age
FROM Customers
ORDER BY age DESC;

Here, the SQL command selects unique ages and orders them in descending order from the Customers table.

To learn more, visit SQL ORDER BY.

Did you find this article helpful?