急求一个查询语句 select count(*) from t1, t2 where t1.peid = t2.peid不会是这样吧?? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 To应该得到如下结果集T1表中的所有记录 + 编号PEID在表T2中对应的记录个数------------------------------PEID NAME ... Count(T2.*) Where T2.PEID = T1.PEID select t1.peid,count(t2.peid) from t1,t2 where t1.peid = t2.peid(+) group by t1.peid select t1.*,nvl(count(t2.peid),0) as c from t1,t2 where t2.peid=t1.peid group by t1.peid SELECTT1.*, COUNT(T2.PEID) OVER ()FROM T1 LEFT OUTER JOIN T2 ON T1.PEID = T2.PEID; select t2.*,decode(t1.dd,null,0,t1.dd) testfrom test t2,(select count(d) dd,d from test1 group by d) t1where t2.a=t1.d(+) oralce 行转列的问题求大神 这个delete的sql怎么写? oracle中是否有sql语句字符长度的限制? 怎样删除lob类型的索引! Oracle的日期时间字段如何分别取出年、月、日存到3个新的字段? 在分区表中插入数据后,怎么看不到数据阿?急!!!! 如何将块中一个变量的计算结果传到块外, 游标溢出,各位帮帮我呀!! 关于Oracle的版本及备份问题? solaris studio 运行dbx 调试错误 如何收集基于表的SQL语句? 备份还原的问题~~
应该得到如下结果集T1表中的所有记录 + 编号PEID在表T2中对应的记录个数
------------------------------
PEID NAME ... Count(T2.*) Where T2.PEID = T1.PEID
group by t1.peid
T1.*
, COUNT(T2.PEID) OVER ()
FROM T1 LEFT OUTER JOIN T2 ON
T1.PEID = T2.PEID
;
from test t2,(select count(d) dd,d from test1 group by d) t1
where t2.a=t1.d(+)