Fetching only Unique(Distinct) Rows.

There are 2 ways to get unique rows from Sql-Server:-

1st way using Distinct clause:-

Select Distinct Col_Name from Table;

2nd way using Group By clause:-

Select Col_Name from Table group by Col_Name;