How to select last 10 rows from MySQL code example

Example: mysql get last row

SELECT fields FROM table ORDER BY id DESC LIMIT 1;