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 

 

Learn SQL from A to Z at LearnSQL.com

Answer 2

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

 

Learn SQL from A to Z at LearnSQL.com

Answer 3

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

 

Learn SQL from A to Z at LearnSQL.com