If you have combination of multiple columns that you want to check duplicates. 
For example : Check duplicates for combination of
 AGE,NAME,SEX,DOB,CITY
Sql will be :
select AGE,NAME,SEX,DOB,CITY,count(1) 
from Employees 
group by AGE,NAME,SEX,DOB,CITY 
having count(1) >1;
No comments:
Post a Comment