未用order by
SELECT ROWNUM,U.* FROM USR U
使用了order by
第一种:rank() over(order by 字段名)
SELECT RANK() OVER(ORDER BY U.SORT) ROWNO,U.* FROM USR U ORDER BY U.SORT
如果sort相同,则rowno相同
第二种:row_number() OVER(ORDER BY 字段名)
SELECT row_number() OVER(ORDER BY U.SORT) ROWNO,U.* FROM USR U ORDER BY U.SORT
如果sort相同,则rowno按顺序排