[紧急高分裸体求助] SQL 语句 select ColA from Table where colB=0 and ColA in (select /*+FIRST_ROWS*/ ColA from Table where ColB=1) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 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 select colA from (select colA, colB, decode(colB, 1, 1, 0, -1, -10000) colC from table_name) tgroup by colAhaving sum(colC)=0 select cola from table_name where colb = 1 intersect select cola from table_name where colb = 0; 求指点:VMware中xp3死活装不上Oracle 10g 求高手写个sql啊,最小值最大值问题 使用同义词的时候出现了错误:表或视图不存在 ORACLE 触发器 代码 Oracle 10g 政则表达式介绍 紧急求救:Oracle数据被删除了 簡單問題:Synonyms 一个关于data字段的问题 马年过去,迎来羊年。为了感谢CSDN的朋友们,散分! 我在客户端用exp命令导服务器上oracle数据库时,报了ora-00904的错,是什么原因? classes12-9i.jar这个驱动从哪找? 一个简单的关联表更新问题
where colB = '1'
and exists(select 1 from table_name where colA = a.colA and colB='0')
(select colA, colB, decode(colB, 1, 1, 0, -1, -10000) colC from table_name) t
group by colA
having sum(colC)=0
intersect select cola from table_name where colb = 0;