How to get last 5 records

[rahul]

hi ,
     i have a table more than 5000 records and i just want to see last n numbers of records from my table is this possible and how to achieve this with sufficient query

[phpdeveloper]

This is very easy to get last n numbers of records from data base you can try like this

Code: [Select]

SELECT columnNames 
FROM YourTableName
ORDER BY columnNAme  DESC
LIMIT 5
Hope this will help you.