/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 vote267 views1 answer
Delete row mssql
SQL
0 vote267 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
0 vote273 views1 answer
Grepper sql workbench download
SQL
0 vote308 views1 answer
Cartesian product sql
SQL
0 vote236 views1 answer
Java spring boot connect to sql server
SQL
1 vote289 views3 answers
Union SQL
SQL
8 votes294 views1 answer
Oracle search code in packages
SQL
0 vote257 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
0 vote265 views6 answers
Unique key in sql
SQL
2 votes271 views1 answer
Oracle sql concatenate results into string
SQL

Share