What is an Alternative way of getting Distinct or Unique records in SQL-Server?

 Posted by vishalneeraj-24503 on 11/26/2013 | Category: Sql Server Interview questions | Views: 2602 | Points: 40

With the help of Group-By clause,we can get unique records:-

select program_name,program_desc,created_date from program_details
group by program_name,program_desc,created_date order by program_name,program_desc,created_date;

Apart from Distinct clause used in select statement, we can get the same records using Group-by clause.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response