/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 vote259 views1 answer
Setval postgres example table id
SQL
3 votes284 views1 answer
APEX elapsed time
SQL
0 vote280 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
7 votes280 views3 answers
Sql set
SQL
0 vote257 views1 answer
Group_concat only returns one row
SQL
0 vote265 views1 answer
Create table with float datatype in sql server
SQL
0 vote253 views1 answer
Nueva tabla mysql
SQL
19 votes279 views6 answers
Mysql if null
SQL
11 votes694 views4 answers
Reset identity column values in sql server
SQL
0 vote264 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL

Share