What is an Alternative way of getting Distinct or Unique records in SQL-Server?

Answer:

With the help of Group-By clause,we can get unique records:-

select program_name,program_desc,created_date from program_details
group by program_name,program_desc,created_date order by program_name,program_desc,created_date;

Apart from Distinct clause used in select statement, we can get the same records using Group-by clause.