select trunc(hired), count(*) hired_today, sum(count(*)) over (order by trunc(hired)) as running_totalfrom empgroup by trunc(hired)
http://sqlfiddle.com/#!4/4bd36/9
select trunc(hired), count(*) hired_today, sum(count(*)) over (order by trunc(hired)) as running_totalfrom empgroup by trunc(hired)
http://sqlfiddle.com/#!4/4bd36/9
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
