[紧急高分裸体求助] SQL 语句

[realmud]

表格如下: Table

ColA ColB
a 1
a 0
b 1
c 0
...

当一条记录ColB 为1时，则可能存在另一条ColA相同，但是ColB 为0的纪录。
求一SQL, 能返回出所有ColB 为1时，相对应ColB为0的记录的ColumnA。如果没有相应ColB为0的记录，则不显示.

[old_programer]

select ColA from Table where colB=0 and ColA in (select /*+FIRST_ROWS*/ ColA from Table where ColB=1)

[bluecocoqd]

select colA from table_name a
where colB = '1'
and exists(select 1 from table_name where colA = a.colA and colB='0')

[沝林]

select cola from Table where colb in (0,1) group by cola having count(distinct colb) = 2

[zzwind5]

select colA from
(select colA, colB, decode(colB, 1, 1, 0, -1, -10000) colC from table_name) t
group by colA
having sum(colC)=0

[tommysun]

select cola from table_name where colb = 1
intersect select cola from table_name where colb = 0;