/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

4 votes323 views1 answer
Sql delete multiple conditions
SQL
0 vote310 views1 answer
Sql change primary key to composite key
SQL
3 votes322 views5 answers
Sql select
SQL
6 votes308 views2 answers
Insert into select mysql
SQL
0 vote289 views1 answer
Sql server cannot create database diagram
SQL
7 votes302 views2 answers
What is sql clause
SQL
18 votes295 views4 answers
Uninstall mysql on ubuntu
SQL
2 votes286 views2 answers
Mysql get time from datetime
SQL
1 vote296 views1 answer
Postgres set column equal to another
SQL
0 vote323 views1 answer
Create a plsql object
SQL

Share