More than 5 years have passed since last update.

SQLServerで、MySQLのLIMIT句、OFFSET句みたいなもの

Last updated at 2014-06-11Posted at 2014-06-11

SQLServer 2008以前では副問い合わせにしてROW_NUMBER()を使って絞り込みます。

SELECT * FROM (
  SELECT
    ROW_NUMBER() OVER(ORDER BY ba.LASTUPDATE DESC) as RN
    , *
  FROM T_TEST as ba
) as t
where t.RN BETWEEN 51 AND 100

SQLServer 2012ではOFFSET-FETCH句が使えるようになりました。

SELECT *
FROM T_TEST
ORDER BY LASTUPDATE DESC
OFFSET 50 ROWS
FETCH NEXT 50 ROWS ONLY