SQL中如何查找重复的数据

发布网友发布时间：2022-04-07 16:58

共5个回答

懂视网时间：2022-04-07 21:20

SELECT t1.* 2 FROM t1, 3 (SELECT name,ADD 4 FROM t1 5 GROUP BY name,ADD HAVING COUNT(1) > 1) AS t2 6 WHERE t1.name = t2.name 7 AND t1.ADD = t2.ADD;

SQL查找重复项目

标签：

热心网友时间：2022-04-07 18:28

SELECT ROOMCODE, OCERTNO, STATE, SYS
FROM TABLE_NAME
WHERE ROOMCODE IN (SELECT ROOMCODE
FROM TABLE_NAME
GROUP BY ROOMCODE
HAVING COUNT(*) > 1)
AND STATE = 0;

热心网友时间：2022-04-07 19:46

select id, name, memo
from A
where id in (select id from A group by id having count(1) >= 2)
以上回答你满意么？

热心网友时间：2022-04-07 21:20

select count(*),roomcode from 表名 group by roomcode having count(*)>1

热心网友时间：2022-04-07 23:12

select * from table
where roomcode in
(
select roomcode from table
group by roomcode
having count(roomcode) > 1
)
and state = 0