/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 vote364 views1 answer
Sql server cast date dd/mm/yyyy
SQL
13 votes379 views2 answers
Get date from now() mysql
SQL
0 vote326 views1 answer
Oracle index hint multiple tables example
SQL
0 vote335 views1 answer
How much table store postgres
SQL
0 vote346 views2 answers
Postgresql get last day of month
SQL
12 votes351 views1 answer
Psql drop column
SQL
0 vote381 views1 answer
Sql query use select name inside where clause
SQL
1 vote597 views1 answer
Postgres convert text to number
SQL
-1 vote346 views1 answer
Sql set max value in column
SQL
1 vote348 views1 answer
Pagination sql
SQL

Share