今天有个需求:group by分组后,需要统计总条数
oracle:
select count(1) from
(select t.workday from NEWSTAFF_WORK_TEMPLETE t where t.position=nsp.id group by t.workday) days
今天有个需求:group by分组后,需要统计总条数
oracle:
select count(1) from
(select t.workday from NEWSTAFF_WORK_TEMPLETE t where t.position=nsp.id group by t.workday) days