/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 vote259 views1 answer
Oracle plan hash value
SQL
0 vote236 views1 answer
Oracle for loop on list
SQL
1 vote226 views1 answer
Alter add syntax
SQL
0 vote208 views1 answer
How to install Firebird
SQL
1 vote222 views1 answer
Encrypt password postgresql
SQL
0 vote230 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote219 views1 answer
Query to insert image
SQL
0 vote233 views1 answer
Drop column from table if exist on live server mysql
SQL
0 vote232 views1 answer
Power bi find all ids not in other tables
SQL
4 votes237 views4 answers
Oracle tablespace tables list
SQL

Share