SQL SELECT DISTINCT Statement

In the table, duplicate values may be included. That's not a problem, but sometimes you might want to just list different values (distinct).

Keyword DISTINCT is used to return only different values.

Grammar:

SELECT DISTINCT column name from table name

Using DISTINCT Keywords

If you want to pick all the values from the company column, we need to use the SELECT statement:

SELECT Company from Orders

"Orders" table: Company

	OrderNumber
Ibm	3532
W3school	2356
Apple	4698
W3school	6953

Results:

Company
Ibm
W3school
Apple
W3school

Note that in the result set, W3school is listed two times.

To select only a different value from the company column, we need to use the Select DISTINCT statement:

DISTINCT

Results:

Company
Ibm
W3school
Apple

Now, in the result set, "W3school" is listed only once.

DISTINCT can also be used in conjunction with count (), such as:

SELECT COUNT (DISTINCT company) from company;

Top

0

Step

SQL SELECT DISTINCT Statement