How to avoid duplicate values in SQL-Server?

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

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

Syntax:-
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