/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 vote261 views2 answers
How to take recent row without limit in mysql
SQL
1 vote201 views1 answer
How to fetch alternate records from two tables
SQL
1 vote196 views1 answer
Display total number of tables in mysql
SQL
1 vote185 views1 answer
Oracle get current schema
SQL
0 vote189 views1 answer
Back up stored procedures mysql
SQL
0 vote231 views1 answer
Implode in sql query
SQL
-1 vote193 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote182 views1 answer
Online sql testing tool
SQL
0 vote219 views1 answer
Sql quary stuf
SQL
0 vote185 views2 answers
Default constraint in ms sql
SQL

Share