More than 3 years have passed since last update.

SQL 行数指定

Last updated at 2021-07-20Posted at 2021-07-20

MySQL

LIMIT句
取得行数の上限を設定

SELECT column_name FROM table_name LIMIT number

TOP句
先頭から指定した行数を取得

SELECT TOP (number) column_name FROM table_name;

ROWNUM句
number1からnumber2行目を取得

SELECT column_name
FROM table_name
WHERE ROWNUM BETWEEN number1 AND number2;