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 

 

70+ SQL courses for beginners and professionals

Answer 2

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

 

70+ SQL courses for beginners and professionals

Answer 3

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

 

70+ SQL courses for beginners and professionals