/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 vote141 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
0 vote150 views1 answer
Convert polygon to text in mysql
SQL
0 vote137 views1 answer
C# check if mysql query modified rows
SQL
0 vote135 views1 answer
Java mysql date format
SQL
2 votes141 views1 answer
Pdo mysql insert
SQL
2 votes183 views2 answers
Postgres drop column if exists
SQL
5 votes305 views2 answers
How to ascending order in sql
SQL
0 vote167 views1 answer
Sql create and grant user access to database
SQL
1 vote157 views2 answers
Mysql insert generate serie
SQL
6 votes124 views2 answers
Mysql version check cmd
SQL

Share