分页求条数？oracle，求得个总的数据条数要和信息数据的条数所对应

Question

select count(*)
from t21_eap_acc_base_info a left join t21_eap_acc_punish_info b on a.accbaseid = b.accbaseid where 1 = 1
group by a.accbaseid, a.usercode , a.username ,a.belongorglevel ,a.happenorgname ,a.happendeptname ,a.postlevel ,a.joblevel ,a.createtime
order by a.username

请问这条SQL咋样求出他的总的条数，用于分页。或者说有没有更好的方法

Answer 1

http://q.cnblogs.com/q/45330/