SQL SERVER DISTINCT CLAUSE

Ankit Singh

Total Post:341

Points:2389
Posted by  Ankit Singh
 622  View(s)
Ratings:
Rate this:
what is   use of distinct clause in sqlserver.
  1. aditya kumar Patel

    Post:254

    Points:1810
    Re: SQL SERVER DISTINCT CLAUSE

     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

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!