/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

2 votes181 views1 answer
Mysql change data type of column
SQL
1 vote162 views1 answer
Real world example of nosql
SQL
7 votes147 views1 answer
Alter table add key sql
SQL
0 vote178 views1 answer
List all functions and procedures in postgres query
SQL
0 vote216 views1 answer
Get null value in sql
SQL
0 vote171 views1 answer
Mysql search multiple tables
SQL
0 vote212 views1 answer
Sqlite get date only
SQL
1 vote197 views1 answer
Sql set auto increment back to 0
SQL
1 vote200 views1 answer
Myql find duplicates
SQL
0 vote182 views1 answer
Mysql_union
SQL

Share