Getting dates between records in mysql

1. SELECT * FROM table WHERE date_col BETWEEN '2008-10-01 00-00-00' AND '2008-12-12
23:59:59'

SELECT * FROM person WHERE dateOfBirth BETWEEN '11/31/2010' AND '12/31/2010';

getting the last record in mysql:

SELECT * FROM table_name ORDER BY sort_column DESC LIMIT 1;

SELECT * FROM student ORDER BY rollNumber DESC LIMIT 1;
SELECT * FROM student WHERE classId=1 ORDER BY rollNumber DESC LIMIT 1;