Welcome to collectivesolver - Programming & Software Q&A. A website you can trust. All programs tested and works. Contact: aviboots(AT)netvision.net.il
Bonsai Boy of New York Bonsai Trees and Accessories

BlueHost Web Hosting

Liquid Web iThemes WordPress Hosting

Ecommerce Software - Best Ecommerce Platform Made for You - Free Trial

DreamHost Web Hosting


getResponse autofunnels

Liquid Web Cloud VPS Hosting

11,407 questions

15,557 answers

573 users

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 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 by avibootz
0 votes
SELECT * FROM (
    SELECT * FROM your_table_name ORDER BY id DESC LIMIT 25
) sub

 




answered Oct 9 by avibootz
...