/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 vote210 views1 answer
Sql server inner join convert collation
SQL
-1 vote232 views1 answer
Pl/sql how to delete a trigger
SQL
1 vote231 views1 answer
Age postgres
SQL
3 votes203 views3 answers
Mysql select table names
SQL
3 votes206 views1 answer
Oracle apex message quit website
SQL
0 vote254 views3 answers
Postgres trim string
SQL
2 votes212 views1 answer
Sqlite indexes
SQL
-1 vote237 views1 answer
Select first rows postgresql
SQL
0 vote237 views1 answer
How to generate ids in sql
SQL
0 vote212 views2 answers
Null value in column violates not-null constraint
SQL

Share