/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 vote110 views1 answer
Assign value to var in SQL
SQL
2 votes123 views1 answer
How to create sql database
SQL
6 votes89 views3 answers
Can you update NULL in sql
SQL
0 vote109 views1 answer
Lesser than or equal to symbol in postgres
SQL
0 vote105 views1 answer
How to declare variable date in mysql
SQL
1 vote107 views2 answers
Mysql: command not found
SQL
0 vote125 views1 answer
Sql server rtrim everything after character
SQL
0 vote118 views1 answer
Unique index in mysql
SQL
-1 vote102 views1 answer
How to format tables in sqlplus
SQL
0 vote61 views1 answer
Delete all rows from table sqlite
SQL

Share