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
Use Distinct clause select query
select distinct Emp_Name ,Emp_Sal from Employee