Friday, May 2, 2008

Duplicate Records Count

SELECT empname,COUNT(empname) FROM test2 GROUP BY empname
HAVING COUNT(empname) > 1
SELECT COUNT(*),empname FROM test2 GROUP BY empname HAVING COUNT(*)>1
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)