求SQL语句

[l_chlmh]

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

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

[gogodiy]

这样？

select * from table1 where a=b and a<>c and b<>c

[xuam]

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

[gogodiy]

如果考虑性能的话，最好能给字段A加个聚集索引。

[dodolzc10]

select * from tab
where a=b and a<>c

[以学习为目的]

select * from tb where a=b and b<>c

--or
select  *  from  tb 
except 
select * from tb where a=b and  b=c

[l_chlmh]

谢谢兄弟们，我是说A,b一样的字段，C不同。

[快溜]

select * from tb a
where exists(select 1 from tb where a.A=A and a.B=B and C<>a.C)

[SQL77]

SELECT A,B FROM TB GROUP BY A,B HAVING COUNT(C)>=2

[xuam]

with T1 as
(select *  from TB where a=b);
select *  from T1 where exists (select c from T1 group by c having count(1)>1)

[老白猫]

[Quote=引用 8 楼 的回复:]

SELECT A,B FROM TB GROUP BY A,B HAVING COUNT(C)>=2
[/Quote]
+1 楼主应该就这意思