查询名字有重复的企业

SELECT
*
FROM
inventory i
GROUP BY
i.unit_detailed_name
HAVING count(i.unit_detailed_name)>1

 

参考文章：https://blog.csdn.net/xusheng__zhang/article/details/78376781