+ 1

sql limit offset

in the SQL lesson on limiting results from an offset, shouldn't the record ID start from 2 instead of 4??

10th Aug 2016, 12:26 PM
Loki Sivakumaran
Loki Sivakumaran - avatar
3 Antworten
+ 1
what's the problem when it starts from 4
10th Aug 2016, 1:05 PM
Ziyaan Hassan
Ziyaan Hassan - avatar
0
well the offset is 3 and since the IDs are starting from 0, shouldn't the results be from 2? Please correct me if I'm wrong
10th Aug 2016, 1:08 PM
Loki Sivakumaran
Loki Sivakumaran - avatar
0
if offset is 3 results would start from 4?
10th Aug 2016, 1:13 PM
Ziyaan Hassan
Ziyaan Hassan - avatar