select last 100 rows code example Example: php sql last 10 rows SELECT * FROM big_table ORDER BY A DESC LIMIT 10