Monday, September 6, 2010

How to find duplicate records in a table ?

select * from emp

group by (empid)

having count(empid)>1




--------------------------------------------------------------------------------

select * from emp where EmpID in(select EmpID
from emp
group by EmpID having count(EmpID)>1)

No comments:

Post a Comment

MCP 2025-11-25 vs. MCP 2026-07-28

A comparison of the major protocol changes introduced in the MCP 2026-07-28 specification. The following table co...