6/16/09

Phân trang by S2DAO

SELECT * FROM (
SELECT ROWNUM AS S2DAO_ROWNUMBER, S2DAO_ORIGINAL_DATA.* FROM (
SELECT * FROM A
) S2DAO_ORIGINAL_DATA
) WHERE S2DAO_ROWNUMBER BETWEEN 1 AND 20 AND ROWNUM <= 20 ORDER BY S2DAO_ROWNUMBER

No comments: