分页检索SQL文

// 当前第几页 curPageNo

// 每页最大记录数 maxperpage

int from = (curPageNo - 1) * maxperpage + 1;
int to = curPageNo * maxperpage;

SELECT * FROM (

SELECT ROWNUM POS, A.* FROM (SELECT * FROM JG_CLXX A WHERE 1 = 1 ORDER BY A.JGSJ DESC)  A

) 

WHERE POS BETWEEN from AND to