simple sql - how to select last 5 rows

this is really simple

how do you select the last n rows of a table

cheers

dion

found the answer

the mysql way is to use ‘limit’

the Microsoft way is to use ‘TOP’

The methods vary depending on which database you are talking to. But,
generally you would sort the table in reverse order then limit the
results to the first 5 rows.

In MySQL it would be something like:

select * from sometable order by somecolumn DESC LIMIT 5;

-Larry