/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 vote110 views3 answers
Mysql get age from date
SQL
19 votes119 views6 answers
What is mySQL
SQL
3 votes129 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote106 views1 answer
Sql random decimal
SQL
0 vote116 views1 answer
Flask sqlalchemy update row
SQL
-2 votes147 views3 answers
How to fetch first 10 rows in sql
SQL
0 vote130 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote74 views1 answer
Connection error in mysql workbench
SQL
0 vote113 views1 answer
Sqlplus change user
SQL
4 votes116 views2 answers
How to delete row in sql
SQL

Share