Home > DeveloperSection > Forums > SQL SERVER DISTINCT CLAUSE
Ankit Singh

Total Post:341

Points:2389
Posted on    November-05-2015 10:02 PM

 .NET SQL Server 
Ratings:


 2 Reply(s)
 343  View(s)
Rate this:
what is   use of distinct clause in sqlserver.


aditya kumar Patel

Total Post:250

Points:1782
Posted on    November-05-2015 10:21 PM

 The SQL Server (Transact-SQL) DISTINCT clause is used to remove duplicates from the result set.         The DISTINCT clause can only be used with SELECT statements.

 Select normal query

Write semple query in sqlserver.

select  Emp_Name ,Emp_Sal  from Employee

 

result:

 



Use Distinct clause select query

select distinct Emp_Name ,Emp_Sal  from Employee

 

 

 


Modified On Nov-05-2015 10:22:02 PM

John Smith

Total Post:102

Points:720
Posted on    November-06-2015 4:38 AM


Don't want to miss updates? Please click the below button!

Follow MindStick