Description:
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:
https://www.youtube.com/watch?v=QYWSsCXfjz0&feature=youtu.be
Queries used:
Select Distinct city from Person.Address;
Select distinct city,stateprovinceid from Person.Address;
Share this link via
Or copy link































