Monday, 14 May 2012

Get duplicate records

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

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)