How to select a range of rows (N1 to N2) from a MySQL table with SQL

2 Answers

0 votes
-- 10 rows start from row number 6

SELECT * FROM your_table_name LIMIT 5, 10 

 



answered Oct 9, 2019 by avibootz
edited Oct 10, 2019 by avibootz
0 votes
-- 10 rows start from row number 6

SELECT * FROM your_table_name LIMIT 10 OFFSET 5

 



answered Oct 10, 2019 by avibootz

Related questions

3 answers 618 views
2 answers 298 views
1 answer 198 views
1 answer 238 views
1 answer 267 views
...