/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 vote267 views2 answers
Mysql set foreign_key_checks=0
SQL
0 vote283 views1 answer
Mysql collation portugues brasil
SQL
0 vote253 views1 answer
Replace content value from old to new sql
SQL
0 vote256 views1 answer
Mysql beautifier terminla
SQL
0 vote305 views1 answer
Sql doesn't contain
SQL
0 vote245 views1 answer
Mysql jdbc timezone
SQL
0 vote269 views1 answer
Mysql cli output to a file
SQL
29 votes255 views5 answers
Mysql show table structure
SQL
0 vote247 views1 answer
Hw to delete a procedure in pl sql
SQL
0 vote249 views1 answer
Using GROUP BY in MySQL Join Table
SQL

Share