求一条查询语句。。。。。望高手指教! select id, count(id) from b , a awhere id(+)= a.id(+)group by id看看这样可不可以 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select a.aid,(select count(*) from b where b.aid=a.aid) as count from a select a.aid,count(b.aid) from a,b where a.id(+)=b.aid group by a.aid select a.id,nvl((select count(1) from b where a.id=id),0) count from a; select a.id,nvl((select count(1) from b where a.id=b.id(+)),0) count from a; select a.aid,count(b.aid) from a,b where a.id=b.aid(+) group by a.aid select a.id, NVL(c.num,0) from a,( select aid, count(*) num from b group by aid ) cwhere a.id=c.aid(+) sql 性能优化 oracle11gR2安装 SQL语句小问题 Oracle Enterprise manager 的问题 请帮忙,谢谢! 求助'这个试图如何优化?? 哪种MV的更新方式更好? 存储过程的问题!大家帮帮忙呀!急 “POSIX standard”是什么含义?谢谢 ORA-12154: TNS:could not resolve the connect identifier specified问题求解 使用IMP导入,报“对象已存在”的错误 装 oracle时,不装oem行不行? 在ORACLE存储过程怎样返回动态执行语句产生的记录集
( select aid, count(*) num from b group by aid ) c
where a.id=c.aid(+)