标量子查询加聚合函数sql改写一
摘要：标量子查询的语句： select /*+ GATHER_PLAN_STATISTICS dwtest */ empno, (select count(*) from DEPT1 b where b.id = a.id) as d, (select sum(x) from DEPT1 b where
阅读全文
posted @ 2023-02-02 17:36
02 2023 档案
