0

In limit query, what if do not have a particular column which is in serial order then how do we take records from 100 to 150.

7th Sep 2016, 5:22 PM
Neeraj Pandey
Neeraj Pandey - avatar
5 Antworten
+ 1
Use ORDER BY. SELECT * FROM mytable ORDER BY mycolumn LIMIT 99, 51; (Sorry, I was 1 off.)
7th Sep 2016, 5:42 PM
Zen
Zen - avatar
+ 1
data from 151 to 170: SELECT * FROM table name ORDER BY columnname LIMIT 150, 20; (Sorry, I was 1 off.)
7th Sep 2016, 5:48 PM
Zen
Zen - avatar
+ 1
We need set unique I'd as primary and then order by Asc than limit to 100 to 150
8th Sep 2016, 4:48 AM
Maggi Maggi
Maggi Maggi - avatar
0
so what if I want to take data from 151 to 170.. SELECT * FROM table name ORDER BY columnname LIMIT 151, 19; Is it??
7th Sep 2016, 5:35 PM
Neeraj Pandey
Neeraj Pandey - avatar
0
c'est une super app
8th Sep 2016, 7:02 PM
Hissene Abdelwahid
Hissene Abdelwahid - avatar