How to select from DB only 5 records. Use MySQL

Question

I have a sql select:

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

But I wanna select only 5 records. If I can do this using the SQL tools?

And If I wana select >= 5 records (more than 5 records)?

Answer 1

Here is the 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;

To know more about LIMIT

---

Edit

I believe >= 5 records means leaving first 5 records and get another 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;

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;