Home SQL - LIMIT query
Reply: 0

SQL - LIMIT query

user416 Published in April 20, 2018, 6:02 pm

SELECT * FROM Employees ORDER BY EmployeeID LIMIT(5,3);

I want to select only 3 records that are the 5th, 6th and 7th records in a table called Employees. This Employees table consists of 100 records.

I tried using "LIMIT" function as stated in the code but it was not working - I do not understand where have I gone wrong.

Thanks in advance for helping me out.

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.313722 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO