[{"friendlyName":"text","name":"Heading","uid":"9a12281e-9a7d-451c-bd4e-1075b54aae37","widgetData":{"html":"

Distinct or SQL Server SELECT DISTINCT

\r\n\r\n

DISTINCT Keyword in SQL Server SELECT statement is used to return only unique records from a database table.

\r\n\r\n

Syntax: SELECT DISTINCT Column _name FROM Table_name.

\r\n\r\n

Example: Consider following scenario. Let say we have a sales order header tables containing Customer related purchase information. From this table we have to retrieve all the customers’ id (Note: in this post queries are executed on adventure works database. Click this to know how to get Adventure Work Database.)

\r\n\r\n

Query: SELECT DISTINCT CustomerID FROM [AdventureWorks2014].[Sales].[SalesOrderHeader];

\r\n\r\n

Result: Missing Image 1

\r\n\r\n

We can combine multiple columns with DISTINCT keyword.

\r\n\r\n

Syntax: SELECT DISTINCT COL1, COL2, COL3, ...COLN FROM table_name

\r\n\r\n

Now uniqueness will be measure on the basis of all the listed column

\r\n\r\n

Example: Let’s assume as per our requirement we have to find list down all the available product Class, Style and its Product line from product table. Execute below query to achieve our goal.

\r\n\r\n

Query: SELECT DISTINCT ProductLine,Class,Style FROM [AdventureWorks2014].[Production].[Product]

\r\n\r\n

WHERE ProductLine IS NOT NULL AND Class IS NOT NULL AND Style IS NOT NULL;

\r\n\r\n

Result:Missing Image 2

\r\n\r\n

Still having queries on distinct keyword. Leave a comment we revert back ASAP.

\r\n\r\n

Interview Question: How to remove duplicate records from a database table?

\r\n"}}]