Question

How to select the last N rows from a MySQL table with SQL

Answer 1

SELECT * FROM your_table_name ORDER BY id DESC LIMIT 25 

 

WordPress Hosting Recommended by WordPress.org

Answer 2

SELECT * FROM (
    SELECT * FROM your_table_name ORDER BY id DESC LIMIT 25
) sub
ORDER BY id ASC

 

WordPress Hosting Recommended by WordPress.org

Answer 3

SELECT * FROM (
    SELECT * FROM your_table_name ORDER BY id DESC LIMIT 25
) sub

 

WordPress Hosting Recommended by WordPress.org