I would like to get an sql statement that uses LIMIT and OFFSET and then sorts the results in ASC or DESC order through the user of ORDER BY, something like this:
SELECT * FROM table LIMIT 10 OFFSET 0 ORDER BY DESC
Note: that does not work so any ideas? I tried shuffling around order by to avial.
Thanks, Regards X