/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 vote318 views1 answer
Sqlcmd no headers
SQL
1 vote331 views1 answer
Liquibase alter column type / length
SQL
0 vote312 views1 answer
Test database for sql
SQL
4 votes378 views2 answers
Delete all table oracle
SQL
32 votes332 views6 answers
Insert select
SQL
0 vote245 views1 answer
Oracle last user logon
SQL
1 vote315 views1 answer
Raise application error in oracle
SQL
1 vote294 views1 answer
Crontab every month
SQL
0 vote310 views1 answer
Shell script to log mysql cpu usage
SQL
6 votes316 views2 answers
If not exists insert sql
SQL

Share