会乱的语句:
select k.* from (SELECT rownum sn,u.* FROM USERINFO u order by u_nick_name asc ) k where k.sn >=1 and k.sn<=5
调整后的语句(先排序,再取rownum):
select k.* from (SELECT rownum sn,u.* FROM (Select * From USERINFO order by u_nick_name asc) u ) k where k.sn >=1 and k.sn<=5