Oracle合并不同条件下统计出的总数

select a.sum1, b.sum2 from
(select count(*) as sum1 from docinfo) a,
(select count(*) as sum2 from docinfo where to_char(createtime,'yyyy-mm-dd') < '2021-01-01') b;

活着Viva
原文地址:https://www.cnblogs.com/xxySsm/p/14677574.html