/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 vote169 views1 answer
Drop all tables in azure sql database
SQL
4 votes162 views2 answers
Insert current date in mysql
SQL
3 votes169 views1 answer
Sql is not like
SQL
5 votes188 views2 answers
Get number of columns sql
SQL
6 votes215 views2 answers
Mysql convert timestamp to date
SQL
0 vote189 views1 answer
Select * from mysql.proc
SQL
0 vote167 views1 answer
Replace \n sql
SQL
0 vote167 views1 answer
Mysql date time string format python
SQL
0 vote178 views1 answer
Get schema of table sql
SQL
3 votes175 views2 answers
Tsql join multiple record in one string
SQL

Share