The SQL Server (Transact-SQL) DISTINCT clause is used to remove duplicates from the result set.The DISTINCT clause can only be used withSELECT statements.
Select normal query
Write semple query in sqlserver.
selectEmp_Name,Emp_SalfromEmployee
result:
Use Distinct clause select query
selectdistinctEmp_Name,Emp_SalfromEmployee
Liked By
Write Answer
SQL SERVER DISTINCT CLAUSE
Join MindStick Community
You have need login or register for voting of answers or question.
John Smith
06-Nov-2015http://www.mindstick.com/Articles/66d1ba5a-2c92-4497-8cfe-3bb90b87c9ba/Select%20Command%20in%20SQL%20Server
Anonymous User
05-Nov-2015The 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.