新手查询问题啊，超级容易到手的分啊。谁答对了就给谁

[v192]

如题
表A{a, b , c}
1 11 a
2 22 b
3 11 a
4 44 444
5 22 b
6 66 666

表A里的有些记录是用A.b和A.c联系的 他们相等
我要查出所有这样数据
最后要表A{a, b , c}
1 11 a
2 22 b
3 11 a
5 22 b
怎么做啊

[hnhn]

select a.a,a.b,a.c from A a where (select count(*) from A b where a.b=b.b and a.c=b.c)>1

[zjcxc]

select * from 表A a
where exists(select * from 表A where b=a.b and c=a.c and a<>a.a)

[paoluo]

这样试试

Select * from A Where c Not Like '[a-Z]'

[zjcxc]

select * from 表A a
where exists(select * from 表A where b=a.b and c=a.c and a<>a.a)

[chd2001]

select * from a where (select count(b) from a group by b,c)>2

[xluzhong]

select *
from 表A a
where exists(select 1 from 表A where b=a.b and c=a.c and id<>a.id)

[chd2001]

select * from a where (select count(b) from a group by b,c)>1

[xluzhong]

select *
from 表A a
where exists(select 1 from 表A where b=a.b and c=a.c and a<>a.a)

[paoluo]

那我理解错了

Select * from A T Where Exists(Select * from A Where a<>T.a And b=T.b And c=T.c)

[rds521]

也就是我要修改一条记录的A.c，在同表里有另一条记录的A.c的直为x，这时我就要通过A.b和A.c关联过去查到另一条记录的A.c的直
再看撒！我的目的是这样的

[Well]

select * from 表A a
where exists(select * from 表A where b=a.b and c=a.c and a<>a.a)