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
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