select a.v1,a.v2 from table a, (select v2 from table c group by v2 having count(*) > 1) b where a.v2 = b.v2
忘了添加条件 : select a.v1,a.v2 from table a, (select v2 from table c group by v2 having count(*) > 1) b where a.v2 = b.v2 and ( a.v1='A' or a.v1='B')
select v2 from table where v1='A' or v1='B' group by v2 having count(*)>1
lastdrop:你的语句存在漏洞 如果:表中还有一个字段V3,会出现这种局面 V1 V2 V3 A 12 01 B 12 01 A 12 02 A 13 03 B 13 03
就看需要不需要显示V3了,若不需要则需要加distinct select distinct a.v1,a.v2 from table a, (select v2 from table c group by v2 having count(*) > 1) b where a.v2 = b.v2 and ( a.v1='A' or a.v1='B')
from table a,
(select v2 from table c group by v2 having count(*) > 1) b
where a.v2 = b.v2
select a.v1,a.v2
from table a,
(select v2 from table c group by v2 having count(*) > 1) b
where a.v2 = b.v2 and ( a.v1='A' or a.v1='B')
from table
where v1='A' or v1='B'
group by v2
having count(*)>1
如果:表中还有一个字段V3,会出现这种局面
V1 V2 V3
A 12 01
B 12 01
A 12 02
A 13 03
B 13 03
select distinct a.v1,a.v2
from table a,
(select v2 from table c group by v2 having count(*) > 1) b
where a.v2 = b.v2 and ( a.v1='A' or a.v1='B')