|
谁能告诉我下面二个SQL语句的执行结果是不是肯定一致的
1 SELECT (A.ID_1*100+A.ID_2),A.NAME,NVL(T.TOTAL,0)
2 FROM A, (SELECT (ID_1*100+ID_2) XX,COUNT(*) AS TOTAL FROM B GROUP BY (ID_1*100+ID_2)) T
3* WHERE (A.ID_1*100+A.ID_2) = XX(+) ;
第二条:
1 select a.id_1,a.id_2,a.name,count(b.name) from a,b
2 where
3* (a.id_1=b.id_1(+) and a.id_2=b.id_2(+)
group by a.id_1,a.id_2,a.name
本人智力值5,武力值99。所以有劳各位费心了 |
|