如何从sql数据库中查询重复行
问题描述：
我有这张桌子
column1
1
0
2
4
5
1
8
2
6 >
如何用sql查询得到这样的结果
column1
1
1
2
2
I have this table
column1
1
0
2
4
5
1
8
2
6
How would I get a result like this with sql query
column1
1
1
2
2
答
试试希望它能帮到你
try this hope it will help you
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