SQL 中的分頁

Created: November-22, 2018

SELECT val 
FROM   (SELECT val, rownum AS rnum
        FROM   (SELECT val
                FROM   rownum_order_test
                ORDER BY val)
        WHERE rownum <= :upper_limit)
WHERE  rnum >= :lower_limit ;

這樣我們可以對錶資料進行分頁，就像 web serch 頁面一樣