SELECT column1, COUNT(column1) FROM table_name GROUP BY column1 HAVING COUNT(column1) > 1
DECLARE @table TABLE (column1 int) INSERT INTO @table VALUES (1) INSERT INTO @table VALUES (0) INSERT INTO @table VALUES (2) INSERT INTO @table VALUES (4) INSERT INTO @table VALUES (5) INSERT INTO @table VALUES (1) INSERT INTO @table VALUES (8) INSERT INTO @table VALUES (2) INSERT INTO @table VALUES (6) SELECT * FROM @table WHERE column1 IN ( SELECT t.column1 FROM @table t GROUP BY column1 HAVING COUNT(t.column1) > 1 ) ORDER BY 1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)