/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 vote166 views2 answers
Rebuild index sql server
SQL
11 votes207 views2 answers
You are using safe update mode
SQL
0 vote156 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
0 vote145 views1 answer
Partitioning in oracle-base
SQL
1 vote232 views1 answer
SQL server query column yes or no
SQL
0 vote155 views1 answer
Declarative base sqlalchemy
SQL
0 vote147 views1 answer
Heavy table in mysql
SQL
1 vote155 views1 answer
What is a Database?
SQL
0 vote151 views1 answer
Grant privileges of databse to user
SQL
3 votes151 views1 answer
Laravel paginate raw sql
SQL

Share