last 5 records in sql code example

Example 1: how to get last row of table in sql

mysql> select *from getLastRecord ORDER BY id DESC LIMIT 1;

Example 2: get latest record in sql

ex:
SELECT TOP 1 * FROM [TABLENAME] ORDER BY id DESC

Example 3: php sql last 10 rows

SELECT * FROM big_table ORDER BY A DESC LIMIT 10