Second, this chapter explains the SELECT DISTINCT statement (DISTINCT)

1. DISTINCT Statement (DISTINCT) 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 differentvalues (distinct).

Keyword DISTINCT is used to return only different values.

Grammar:

SELECT DISTINCT column name from table name

Add: 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
Add: SELECT DISTINCT (company) from orders

Results:

Company

Ibm

W3school

Apple

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

Second, this chapter explains the SELECT DISTINCT statement (DISTINCT)