本文主要是介绍查找表中的重复记录,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
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
这篇关于查找表中的重复记录的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!