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

Question

oracle 如何在group by 的语句中使用rownum，实现分页 贴上我的语句：
SELECT s.calluserid,c.callsign, count(msgstatus) as
alls,sum(msgstatus) as success, tochar(sendtime,'yyyy-MM-dd')
FROM rtxsenddata s,rtxcalluserinfo c where
s.calluserid=c.calluserid group by
s.calluserid,c.callsign,tochar(sendtime,'yyyy-MM-dd');

需要对结果集分页，使用rownum，就会报错

Answer 1

SELECT rownum, a.*&nbsp;&nbsp; FROM (<<your complex query including GROUP BY and ORDER BY>>) a