本文介绍了一种使用SQL查询语句来找出数据库表中重复姓名的方法。通过子查询和分组统计，可以有效地筛选出所有重复的姓名记录，并按姓名及编号进行排序。
SELECT NUMBER, NAME
FROM T_SICK_NAME as a
where exists (
SELECT 1
FROM (select NAME
from T_SICK_NAME
group by NAME
having count(*) > 1 ) as b
where a.NAME = b.NAME
)
order by NAME ,NUMBER
SELECT NUMBER, NAME
FROM T_SICK_NAME as a
where exists (
SELECT 1
FROM (select NAME
from T_SICK_NAME
group by NAME
having count(*) > 1 ) as b
where a.NAME = b.NAME
)
order by NAME ,NUMBER
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
