/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

9 votes369 views1 answer
No sql
SQL
0 vote346 views1 answer
Exec procedure oracle
SQL
0 vote347 views2 answers
SQL Server Standard
SQL
2 votes386 views1 answer
Oracle run_duration to number
SQL
-1 vote394 views4 answers
Sql view postgresql
SQL
7 votes363 views3 answers
Postgresql dump and restore db
SQL
1 vote339 views1 answer
Sql server get users
SQL
0 vote337 views1 answer
Sql row number in result set
SQL
8 votes360 views5 answers
Grant permission in postgres
SQL
1 vote350 views1 answer
Copy postgres table from one schema into another
SQL

Share