how to check last 100 records in mysql code example

Example: mysql get last row

SELECT fields FROM table ORDER BY id DESC LIMIT 1;