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 299 views
2 answers 579 views
1 answer 199 views
1 answer 239 views
1 answer 268 views
...