这个用SELECT DISTINCT就可以解决了。 DISTINCT是专门去重复的 SELECT DISTINCT A, B FROM TABLE 去重复的依据就是DISTINCT后边的字段,如果SELECT DISTINCT A FROM TABLE,那么选择不重复的A,SELECT DISTINCT A, B FROM TABLE ,那么选择不重复的A,B组合。 SELECT DISTINCT * FROM TABLE,那么选择不重复的表单行记录。
-- 没太明白你的意思,你看下面的sql符合要求不? select * from table t where A in (select A from table group by A having count(0) > 1) and B in (select B from table group by B having count(0) = 1)