select a.*
from event_bus_events_copy1 a
where a.event_code IN (SELECT b.event_code
FROM event_bus_events_copy1 b
GROUP BY b.event_code
HAVING COUNT(*) > 1)
order by a.event_code asc
sql查询一列中所有重复项
最新推荐文章于 2024-05-30 14:52:09 发布