SELECT a.* FROM a
JOIN (
SELECT count(*), col_name FROM a
WHERE dates = '20240101'
GROUP BY col_name HAVING count(*) > 1
) b
ON a.col_name = b.col_name
where a.dates = '20240101'
查询表中指定列的重复的数据
最新推荐文章于 2024-07-26 14:53:47 发布
SELECT a.* FROM a
JOIN (
SELECT count(*), col_name FROM a
WHERE dates = '20240101'
GROUP BY col_name HAVING count(*) > 1
) b
ON a.col_name = b.col_name
where a.dates = '20240101'