/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 vote331 views1 answer
Soql last week
SQL
2 votes341 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
1 vote382 views1 answer
Last 24 HOUR data in mysql
SQL
0 vote360 views1 answer
Connecting mySQL to STS
SQL
16 votes339 views3 answers
Jwt secret key generator laravel
SQL
8 votes355 views2 answers
Oracle undo usage
SQL
0 vote344 views1 answer
Two inner joins sql
SQL
1 vote314 views1 answer
Oracle current sequence value
SQL
0 vote336 views1 answer
Mysql root localhost run
SQL
5 votes330 views1 answer
Oracle get nls settings
SQL

Share