/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

21 votes119 views7 answers
Table drop if exist sql server
SQL
2 votes151 views1 answer
Match in sql server
SQL
2 votes184 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote152 views1 answer
Mysql sql.gz
SQL
0 vote154 views1 answer
MySql Modify Increment
SQL
2 votes149 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
0 vote175 views2 answers
Uninstall postgresql mac
SQL
2 votes161 views2 answers
How to add not null constraint in sql
SQL
36 votes268 views6 answers
Change column data type sql
SQL
0 vote148 views1 answer
Alasql delete column
SQL

Share