/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 vote124 views1 answer
What is in operator
SQL
0 vote129 views1 answer
Error code 1451 sql
SQL
0 vote146 views1 answer
Cube oracle
SQL
0 vote110 views1 answer
Cara menampilkan user di mysql terminal
SQL
4 votes127 views3 answers
How to describe a table in sqlite3
SQL
0 vote139 views1 answer
Drop table BigQuery table columns
SQL
10 votes161 views1 answer
Oracle all_dependencies
SQL
0 vote130 views1 answer
Allow external access to mysql
SQL
1 vote111 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote134 views1 answer
Insert into select with group by
SQL

Share