oracle 如何在group by 的语句中使用rownum，实现分页

Question

oracle 如何在group by 的语句中使用rownum，实现分页 贴上我的语句：SELECT s.calluserid,c.callsign, count(msgstatus) asalls,sum(msgstatus) as success, tochar(sendtime,'yyyy-MM-dd')FROM rtxsenddata s,rtxcalluserinfo c wheres.calluserid=c.calluserid group bys.calluserid,c.callsign,tochar(sendtime,'yyyy-MM-dd');需要对结果集分页，使用rownum，就会报错

Answer 1

SELECT rownum, a.* 

  FROM (<<your complex query including GROUP BY and ORDER BY>>) a