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;

posted @ 2021-04-19 16:55  xiaoYu&  阅读(248)  评论(0编辑  收藏  举报