比如:
SELECT HTTP_PATH, FILE_NAME ,FILE_NAME_SOURCE FROM" + " ( SELECT * FROM UPLOAD WHERE SER_NO = :SerNo) WHERE ROWNUM <= 1 ORDER BY ROWNUM ASC
先oderby一下,然后skip + take