[SOLVED] Retrieve last ten records from the database

[chelnov63]

Hi,

 

using LIMIT I know how to easily retrieve the first 10 records from the database. But is there an easy way to retrieve the LAST 10 records  from the database? Cheers

 

e.g

 

$sql = "SELECT * FROM employees";

 

How would i retrieve the last 10 records..

 

cheers in advance

[AndyB]

... ORDER by id DESC LIMIT 10

[chelnov63]

DOH!!!!  thanks for that!!!