SQL の LIMIT: 例

例
サンプルデータベース

#1

SELECT employee_id, first_name, last_name FROM employees ORDER BY first_name;

#2

SELECT employee_id, first_name, last_name FROM employees ORDER BY first_name LIMIT 5;

#3

SELECT employee_id, first_name, last_name FROM employees ORDER BY first_name LIMIT 5 OFFSET 3;

#4

SELECT employee_id, first_name, last_name FROM employees ORDER BY first_name LIMIT 3, 5;

#5

SELECT employee_id, first_name, last_name, salary FROM employees ORDER BY salary DESC LIMIT 5;

#6

SELECT employee_id, first_name, last_name, salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 1;

#7

SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1, 1;

#8

SELECT employee_id, first_name, last_name, salary FROM employees WHERE salary = 17000;

#9

SELECT employee_id, first_name, last_name, salary FROM employees WHERE salary = ( SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1, 1 );

テーブル一覧

国

SELECT * FROM countries;

部門

SELECT * FROM departments;

被扶養者

SELECT * FROM dependents;

職員

SELECT * FROM employees;

職種

SELECT * FROM jobs;

拠点

SELECT * FROM locations;

地域

SELECT * FROM regions;

SQL クエリ

実行

クリア整形圧縮

リロード

結果