/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

2 votes127 views1 answer
Pandas to sql index
SQL
0 vote134 views1 answer
Oracle sql procedure return value
SQL
0 vote140 views1 answer
Porcentaje sql
SQL
0 vote136 views1 answer
Change filed order in mysql
SQL
0 vote122 views1 answer
Fetch second word from a string in ms sql
SQL
0 vote131 views4 answers
Best data type to represent money in mysql
SQL
1 vote127 views1 answer
Update from table tsql
SQL
0 vote125 views1 answer
Automate mysql cli query
SQL
0 vote122 views1 answer
Oracle free up space in tablespace
SQL
11 votes122 views2 answers
Having clause
SQL

Share