/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 vote133 views1 answer
Sql select rows with different values in one column
SQL
6 votes118 views2 answers
Mysql version check cmd
SQL
0 vote234 views1 answer
How to use select union and loop
SQL
5 votes145 views1 answer
Oracle list functions
SQL
0 vote144 views1 answer
Recently updated stored procedure in sql server
SQL
0 vote175 views1 answer
Capabilities of sql select statements
SQL
16 votes117 views1 answer
Mysql reset auto increment value
SQL
1 vote151 views2 answers
Mysql add column tinyint default 0
SQL
2 votes130 views1 answer
Update trigger
SQL
1 vote130 views1 answer
Check message id sql server
SQL

Share