oracle分页

 

 

 

select x.*  from

( select row_num() over( order by nvl( score,0) desc) as r,

       t.*  from t_score t

)x

where r between(( 页码-1)*每也行+1) and 页码*每页行数

order by  score desc, s_name