/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 vote155 views1 answer
Run mysql xampp shell
SQL
0 vote97 views1 answer
Get who is hired in january in sql
SQL
6 votes96 views1 answer
Oracle trigger after logon on database
SQL
1 vote108 views1 answer
Oracle create as select
SQL
0 vote111 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
0 vote116 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote101 views2 answers
Azure sql-datenbank
SQL
-1 vote106 views2 answers
Installing mysql on centos 7
SQL
1 vote91 views1 answer
Mysql size int
SQL
0 vote104 views1 answer
How to export only procedures mysql
SQL

Share