/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

27 votes133 views6 answers
Set password mysql
SQL
2 votes124 views1 answer
Postgresql drop primary key constraint
SQL
1 vote109 views1 answer
Regular expression in sql server
SQL
3 votes77 views1 answer
Postgresql where current year
SQL
0 vote103 views1 answer
Prepared statement mysql java delete selected rows
SQL
0 vote110 views1 answer
SQL loop with cursor
SQL
1 vote100 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
6 votes111 views4 answers
Sqlite drop table
SQL
0 vote119 views2 answers
Alter table add multiple columns mysql
SQL
0 vote152 views1 answer
Install postgresql 12 on debian 10
SQL

Share