/SQL/Mysql select last 10 rows

Mysql select last 10 rows

Mysql get last row

SELECT fields FROM table ORDER BY id DESC LIMIT 1;

8

Select last row mysql

SELECT
  (SELECT * FROM tableName ORDER BY col1 LIMIT 1)        AS first,
  (SELECT * FROM tableName ORDER BY col1 DESC LIMIT 1)   AS last
;

4

Source: stackoverflow.com

Mysql select last 10 rows

SELECT * FROM tableName ORDER BY col1 DESC LIMIT 10;

1

Select last N rows mysql

SELECT * FROM (
    SELECT * FROM table ORDER BY id DESC LIMIT 50
) sub
ORDER BY id ASC

0

Source: stackoverflow.com

Similar codes

-1 vote263 views1 answer
Export mysql table to file
SQL
2 votes338 views2 answers
MySql FULL OUTER JOIN
SQL
0 vote267 views1 answer
Oracle sql procedure return value
SQL
0 vote301 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
0 vote285 views1 answer
Radius search with point data in mysql
SQL
0 vote277 views1 answer
Group by max date
SQL
0 vote289 views1 answer
How to define a non primary composite key in sql
SQL
0 vote269 views1 answer
Mysql search multiple tables
SQL
1 vote289 views1 answer
Key validation sql
SQL
0 vote273 views1 answer
Oracle DROP PROGRAM
SQL

Share