Geek Answers Handbook

How to choose from the database only 5 records. Use MySQL

I have 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 want to select only 5 entries . If I can do this with SQL tools?

And if I wana select > = 5 entries (more than 5 entries)?

+4
source share
5 answers

Here is 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 learn more about LIMIT

Edit

I believe that > = 5 entries means leaving the first 5 entries and getting 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;
+4
source 
SELECT employee.name, employee.surname, department.name FROM employee INNER JOIN deparment 
ON employee.id_department=department.id WHERE department.name = 'security'

limit 5;
+2
source 
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 ;
+1
SELECT employee.name, employee.surname, department.name FROM employee INNER JOIN deparment 
ON employee.id_department=department.id WHERE department.name = 'security'
LIMIT 5;
+1

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

+1

More articles:


All Articles