Fetching only Unique(Distinct) Rows.

Posted by vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 351
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;

Comments or Responses

Login to post response