StanLytle
07-26-2007, 10:05 PM
ORDER BY .... DESC LIMIT 4
I understand how this works. It returns the last, in this case 4, whatevers. Is there a way to get the next to the last 4? In other words, in a table that has 100 rows, could this be written to return rows 93-96, instead of 97-100. This is a dynamic table, where the row numbers are incremented as more information is added.
Thanks,
Stan
I understand how this works. It returns the last, in this case 4, whatevers. Is there a way to get the next to the last 4? In other words, in a table that has 100 rows, could this be written to return rows 93-96, instead of 97-100. This is a dynamic table, where the row numbers are incremented as more information is added.
Thanks,
Stan