SELECT ID FROM yourTable GROUP BY ID HAVING (COUNT(ID) > 1) In SQL 2005+ you can do the following and get all of the columns:……
SELECT ID FROM yourTable GROUP BY ID HAVING (COUNT(ID) > 1) In SQL 2005+ you can do the following and get all of the columns:……