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