SQL DISTINCT STATEMENT | SQL TUTORIAL | BEGINNER SQL TUTORIAL | SQL DISTINCT MULTIPLE COLUMNS

In this SQL Tutorial for beginners, we are going to learn how to use SQL DISTINCT statement in SSMS. Distinct statement is used to return unique or different values from a column, or a combination of columns. We will write basic queries to return Distinct column/columns from a table. We will use the Distinct statement on one column, and also the Distinct statement on multiple columns.

How to download Adventureworks Database:

Queries used:

Select Distinct city from Person.Address;
Select distinct city,stateprovinceid from Person.Address;