查询同一表中某些字段相同，剩余字段不同的记录！

[fw819]

例如 表：feng 数据结构如下：

A B C D E F
123 ASD CXZ 22 34 QWE
123 ASD CXZ 13 77 QWE
432 SDF ADD 56 34 RE
DS3 SDF FE 54 12 TY
RT WE F5E 55 88 L6
DS3 SDF UR 44 67 TY

请问如何把 A B 列同时相同的记录查询出来呢？？不甚感激~~

[fw819]

谢谢哈``

[-狙击手-]

JF

[jinjazz]

where a=b

[tim_spac]

select * 
from feng f
where exists (
  select 1 from ( select a,b from feng group by a,b having count(1)>1 ) as b
  where f.a=b.a and f.b=b.b
)

[chuifengde]

select * from feng A where exists(select 1 from feng where a=a.a and b=a.b and checksum(a,b,c,d)<>checksum(a.a,a.b,a.c,a.d))

[中国风]

select *
from feng f
where
(select count(1) from feng where a=f.a and b=f.b)>1