How do you select unique rows using SQL? | SQL Server interview questions

Using the "DISTINCT" clause. For example if you fire the below give SQL in "AdventureWorks", first SQL will give you distinct values for cities , while the other will give you distinct rows.
select distinct city from person.address 
select distinct * from person.address

0 comments:

Post a Comment

Blogger news