SQL select distinct statement

ArticleDirectory

• Syntax:
• "Orders" table:
• Result:
• Result:

 

SQL select distinct statement

Duplicate values may exist in the table. This is not a problem. However, sometimes you may want to list only different values.

The keyword distinct is used to return a unique value.

Syntax:

 
Select distinct column name from Table Name
 

Use distinct keywords

To select all values from the "Company" column, use the SELECT statement:

 
Select company from orders
 

"Orders" table:

Company	Ordernumber
IBM	3532
W3school	2356
Apple	4698
W3school	6953

Result:

Company
IBM
W3school
Apple
W3school

Note that w3school is listed twice in the result set.

To select only different values from the company column, use the select distinct statement:

 
SelectDistinctCompany from orders
 

Result:

Company
IBM
W3school
Apple

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

 

To display data of other columns, use the following syntax:

Select *, count (distinct name) from Table group by name

Result:

ID name count (distinct name)
1 A 1
2 B 1
3 C 1