/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 vote184 views1 answer
Find how many table doesn't contain column in mysql
SQL
1 vote234 views1 answer
Mysql view curren querys
SQL
5 votes191 views1 answer
Mysql add user with all privileges
SQL
0 vote201 views1 answer
Traccar mysql
SQL
1 vote252 views1 answer
Mysql tables max count
SQL
0 vote245 views1 answer
Sql set data from a select query to a temp table and insert
SQL
5 votes190 views1 answer
Postgresql functions
SQL
0 vote263 views1 answer
Start stop mysql linux
SQL
25 votes220 views6 answers
How to change column name in mysql
SQL
4 votes206 views3 answers
Is not null sql
SQL

Share