/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 vote355 views1 answer
Oracle create package specification
SQL
0 vote378 views1 answer
How to get nth number in sql
SQL
0 vote373 views1 answer
How to update sql server version
SQL
5 votes406 views3 answers
Sql server utc to local
SQL
1 vote362 views1 answer
Use of now() in mysql
SQL
20 votes368 views5 answers
Sql show tables
SQL
0 vote347 views1 answer
TSQL function split string
SQL
1 vote375 views1 answer
Hexadec to sql REDSHIFT
SQL
1 vote354 views1 answer
Postgresql last element of array
SQL
4 votes362 views2 answers
Linq join
SQL

Share