How to avoid duplicate values in SQL-Server?

 Posted by Rajesh_Kumar on 1/18/2014 | Category: Sql Server Interview questions | Views: 2021 | Points: 40

With the help of Distinct clause,we can avoid duplicate records:-

Select Distinct column_name from tbl_name;

For Example:-

select distinct project_name from project_master where project_name is not null;

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response