如何从数据库中仅选择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条记录）呢？

- somebody

---

在你的查询中使用 limit。 - Janny

你的“大于等于5”的意思是什么？ - 你的SQL语句是正确的答案，如果有更多的记录它将显示大于5条记录，如果有5条记录它将显示5条，不需要限制。 - Murtaza

@Murtaza 我想选择超过5条记录。也就是说，如果我的表有10条记录，我想看到它们。如果我的表只有3条记录，我不想看到它们。 - somebody

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;

- Mohit S

---

如果我想从整个表中选择超过5条记录怎么办？ - somebody

只需将数字增加到您想要获取的记录数量即可。 - Mohit S

假设您想要获取7条记录，则使用“LIMIT 7”。 - Mohit S

这里是另一个链接，可以了解更多关于LIMIT的内容。 - Mohit S

Answer 2

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

limit 5;

- nesreen

---

好的。如果我想选择大于或等于5条记录怎么办？ - somebody

Answer 3

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 ;

- jpcanamaque

Answer 4

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

- Daniel Camilleri

Answer 5

选择 employee.name , employee.surname , dept.name 从 employee 内部连接 deparment as dept 在 employee.id_department=dept.id 当 department.name = 'security' 限制 5 , 5 ;

- Pankaj Monga