Let's say I want to run a query, but only want specific rows returned in a data set, like rows 11-20 (like a page view). How do I structure my query to do so? Can I use LIMIT somehow?
Yes, for MySQL a LIMIT 10, 10 clause could be used.
Limit 10, 10 will work. This tells me to start on row 11 (as row 0 is the first record) and return the next 10 rows in the results file. Thanks!
