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

3 Answers

0 votes
SELECT * FROM your_table_name ORDER BY id DESC LIMIT 25 

 



answered Oct 9, 2019 by avibootz
0 votes
SELECT * FROM (
    SELECT * FROM your_table_name ORDER BY id DESC LIMIT 25
) sub
ORDER BY id ASC

 



answered Oct 9, 2019 by avibootz
0 votes
SELECT * FROM (
    SELECT * FROM your_table_name ORDER BY id DESC LIMIT 25
) sub

 



answered Oct 9, 2019 by avibootz

Related questions

2 answers 295 views
2 answers 577 views
1 answer 197 views
1 answer 237 views
...