simple sql - how to select last 5 rows

rubyonrails-talk
1

this is really simple

how do you select the last n rows of a table

cheers

dion

2

found the answer

the mysql way is to use ‘limit’

the Microsoft way is to use ‘TOP’

3

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