I've been trying to get a statement to work that will pull the last five records in my table regardless of the number of records.

Can someone show me what the statement would look like. My table is called students.

This is what I've got so far:
PHP Code:
select * from students limit select count(*) from students - 5, 5; 
I've also tried setting the count equal to a variable named studentcount and used it like this:

PHP Code:
select * from students limit studentcount -  5, 5; 
I would like to be able to understand the long way if anyone knows how it can work?