/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

1 vote185 views1 answer
Sql row having max
SQL
0 vote172 views1 answer
Mysql xampp reset root password
SQL
6 votes176 views1 answer
Oracle pl sql source
SQL
0 vote178 views1 answer
Providername system.data. mysql
SQL
3 votes186 views1 answer
Oracle apex message quit website
SQL
0 vote163 views1 answer
Sqlite to csv statement
SQL
0 vote172 views1 answer
T-sql conditional order by multiple columns
SQL
1 vote180 views1 answer
SQL date part only of datetime
SQL
5 votes203 views1 answer
Get column name sql server
SQL
0 vote201 views1 answer
Create-table-with-index-organization
SQL

Share