/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

0 vote193 views1 answer
Java input type sql date
SQL
0 vote188 views1 answer
Kotlin sqlite delete row
SQL
0 vote205 views1 answer
Oracle NLS_CHARACTERSET
SQL
0 vote193 views1 answer
Tsql pad left
SQL
0 vote251 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote209 views1 answer
How to map sql column to custom names
SQL
7 votes181 views1 answer
Oracle reset sequence
SQL
2 votes179 views1 answer
Sql select min value from multiple columns
SQL
0 vote183 views1 answer
What does the -p flag do in mysql cli
SQL
1 vote230 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL

Share