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.
5 odpowiedzi
+ 1
Use ORDER BY.
SELECT * FROM mytable ORDER BY mycolumn LIMIT 99, 51;
(Sorry, I was 1 off.)
+ 1
data from 151 to 170:
SELECT * FROM table name ORDER BY columnname LIMIT 150, 20;
(Sorry, I was 1 off.)
+ 1
We need set unique I'd as primary and then order by Asc than limit to 100 to 150
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??
0
c'est une super app