/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 vote323 views1 answer
Error code 1055
SQL
0 vote332 views1 answer
Postgresql interview questions
SQL
4 votes318 views1 answer
Oracle error compilation line
SQL
2 votes312 views1 answer
Get first 3 letters name in sql
SQL
0 vote319 views2 answers
Sql drop view if exists
SQL
2 votes332 views1 answer
Oracle calculated column
SQL
1 vote355 views3 answers
Postgresql get difference between two dates
SQL
1 vote322 views1 answer
Oracle user last connected
SQL
0 vote333 views1 answer
Sql server concat null
SQL
0 vote333 views1 answer
Day of the week sqlite
SQL

Share