SQL SELECT DISTINCT Statement usage

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 (directory field) column name from table name (AA)

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 AA

"AA" 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.

SQL SELECT DISTINCT Statement usage