column1、column2 两列不唯一：
SELECT 表.*
FROM 表 INNER JOIN(SELECT column1,column2
FROM 表 GROUP BY column1, column2 HAVING COUNT(*)>1) B
ON 表.column1 = B.column1 AND 表.column2 = B.column2;
(SELECT column1,column2
FROM 表 GROUP BY column1, column2 HAVING COUNT(*)>1) B
ON 表.column1 = B.column1 AND 表.column2 = B.column2;
转载于:https://my.oschina.net/u/1377764/blog/410367
扫一扫
586
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
