Saturday, 18 June 2011

How to get duplicate rows from the table ?

Select empno, count (*) from EMP group by empno having count (*)>1;
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)