复杂查询小问题！！！求SQL语句

[l_chlmh]

表假设有三个字段：A B C，

想查询出A\B值相同，C值不相同的情况。

[BenChiM888]

select a,b,c
  from t
 where (a,b) in
(select a,b from t group by a,b having count(distinct c)>1)

[Query_1]

select * from abc where a=b and a<>c and b<>c; 这样可以吗 不知道你的A\B 是不是A和B的意思

[qurihong]

select * from test where a=b and b<>c;

[SKY_4K_PPM]

select * from test where a=b and b<>c;
对的