Fetching Unique Record in Salesforce via SOQL

• Using GROUP BY we are able to fetch the Unique Record in Salesforce 

• GROUP BY returns aggregate result list. 

LIST<AggregateResult> AccListAggregare = [SELECT Name from Account GROUP BY Name];


 also you can use of Count() method in SOQL
 SELECT count(id),Name FROM  Account GROUP BY Name