/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 vote200 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote232 views1 answer
Convert int to varchar sql
SQL
0 vote186 views1 answer
Oracle list index on table
SQL
0 vote207 views1 answer
OFFSET consulta mysql
SQL
-2 votes208 views1 answer
Modify column name in tsql
SQL
2 votes203 views1 answer
How to search table name in stored procedure in sql server
SQL
2 votes212 views2 answers
Mysql find max value row
SQL
0 vote214 views1 answer
Xampp mysql version
SQL
1 vote249 views1 answer
Does insert into overwrite sql
SQL
9 votes199 views2 answers
Get first 3 letters in sql
SQL

Share