R
R
rusgayfer2018-03-09 20:45:42
MySQL
rusgayfer, 2018-03-09 20:45:42

How to output 5 lines from the end skipping the last 5 lines?

I first display the last 5 lines from the database. Now you still need to display the last 5 lines, but skipping these lines that have already been displayed, how to do it? That is, display the last lines, not counting these, then what is before them
SELECT * FROM `users` ORDER BY `id` DESC LIMIT 5

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexey, 2018-03-09
@rusgayfer

SELECT * FROM `status` ORDER BY `id` DESC LIMIT 5, 5

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question