mysql query to get last 10 records code example

Example: mysql get last row

SELECT fields FROM table ORDER BY id DESC LIMIT 1;