How do you select unique rows using SQL?

 Posted by ArticlesMaint on 10/3/2009 | Category: Sql Server Interview questions | Views: 10620

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

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response