如何从sql数据库中查询重复行 [英] How do I query duplicate rows from sql database

问题描述

我有这张桌子

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

这篇关于如何从sql数据库中查询重复行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！