/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

9 votes321 views1 answer
Mysql check date range
SQL
8 votes318 views3 answers
Oracle auto_increment
SQL
0 vote338 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
0 vote280 views1 answer
Select mysql limit to 2 decimal places
SQL
0 vote308 views1 answer
Postgresql heritage
SQL
13 votes322 views3 answers
Sql select from multiple tables without join
SQL
4 votes335 views1 answer
Data types in sql
SQL
4 votes312 views2 answers
Postgresql reset sequence
SQL
0 vote335 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
0 vote357 views1 answer
Oracle pl/sql check if file exists
SQL

Share