SQL LIMIT：示例 - SQL 教程

示例
样本数据库

#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 );

表格列表

countries

SELECT * FROM countries;

departments

SELECT * FROM departments;

dependents

SELECT * FROM dependents;

employees

SELECT * FROM employees;

jobs

SELECT * FROM jobs;

locations

SELECT * FROM locations;

regions

SELECT * FROM regions;

SQL 查询

执行

清除美化缩小

重新加载

结果