mysql - 如何从数据库中仅选择 5 条记录。使用MySQL

Question

我有一个 sql 选择:

SELECT employee.name, employee.surname, department.name FROM employee INNER JOIN deparment 
ON employee.id_department=department.id WHERE department.name = 'security'

但我想选择只有 5 条记录。我是否可以使用 SQL 工具执行此操作？

如果我想选择 >= 5 条记录(超过 5 条记录)？

Answer 1

这是SQL

SELECT employee.name, employee.surname, department.name 
FROM employee INNER JOIN deparment
ON employee.id_department=department.id 
WHERE department.name = 'security'
LIMIT 5;

了解更多 LIMIT

---

编辑

我相信>= 5 条记录 意味着保留前 5 条记录并获得另外 5 条记录。

SELECT employee.name, employee.surname, department.name 
FROM employee INNER JOIN deparment
ON employee.id_department=department.id 
WHERE department.name = 'security'
LIMIT 5,5;