How to find the duplicate records in table in sqlserver?
selct id, count(id) from tablename group by id,ename having count(id)>1
How to delete duplicate records in Table?
selct id, count(id) from tablename group by id,ename having count(id)>1
How to delete duplicate records in Table?
No comments:
Post a Comment