2019年6月11日
sql 查找重复数据，并且重复数据有子集
摘要： SELECT A.* FROM comm_department A INNER JOIN ( select path,count(*) as count from comm_department group by path having count>1 ) B ON B.path=A.path WHERE EXISTS(SELECT * FROM comm_department C WHER... 阅读全文
posted @ 2019-06-11 14:51 八英里 阅读(447) 评论(0) 推荐(0)