/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 vote203 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
-2 votes254 views3 answers
How to fetch first 10 rows in sql
SQL
0 vote197 views1 answer
Transaction database with php
SQL
0 vote188 views1 answer
Execut sql python
SQL
25 votes191 views1 answer
Mysql grant all privileges to a user
SQL
1 vote219 views1 answer
Oracle sequence last_number
SQL
3 votes216 views1 answer
Where id is in list sql
SQL
0 vote189 views1 answer
Oracle sql procedure return value
SQL
5 votes195 views1 answer
Ignore duplicate rows in sqlite
SQL
28 votes202 views4 answers
Mysql delete database
SQL

Share