select last rows?

[blackdog]

is there a way to select the last n rows from a table?

thanks!

[r937]

yes, there is

the last n rows based on which column?

[blackdog]

based on the primary column called 'id'

[someonewhois]

SELECT fields FROM table WHERE 1=1 ORDER BY id DESC LIMIT 30;