O
O
Optimus2016-07-28 10:48:33
MySQL
Optimus, 2016-07-28 10:48:33

Where is the error in the fetch request?

SELECT `id`, `user` FROM `allusers` ORDER BY `user` DESC LIMIT 20,30

I expect 10 entries in the answer (from 20 to 30). Answer:
Display lines 20 - 49 (30 in total , Query took 0.0011 seconds) [user: 5167886 - 3916274]
Am I wrong?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
@
@mgyk, 2016-07-28
Pyan @marrk2

LIMIT 20,10 <- number of records starting from 20

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question