mysql limit last 100 rows code example

Example 1: php sql last 10 rows

SELECT * FROM big_table ORDER BY A DESC LIMIT 10

Example 2: get from database the most recent data limit by 5

$result = mysql_query("SELECT * FROM notes WHERE note_author_id='$u_id' ORDER BY date_time DESC LIMIT 0, 10");