/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 vote292 views1 answer
Less than date query sqlachemy
SQL
7 votes296 views1 answer
Sql server management studio turn on line numbers
SQL
1 vote279 views1 answer
Count of tables in database mysql
SQL
0 vote299 views2 answers
How to install mssql on mac
SQL
2 votes284 views1 answer
Mysql how to store lat,lng
SQL
2 votes307 views1 answer
Ifnull postgres
SQL
1 vote270 views1 answer
Sql only five first row
SQL
0 vote297 views1 answer
Sql get highest date from 3 tabels
SQL
0 vote273 views1 answer
Mssql current date
SQL
1 vote238 views1 answer
Into sql
SQL

Share