/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

65 votes375 views6 answers
Sql add column to table
SQL
3 votes269 views4 answers
Truncate syntax in sql
SQL
4 votes241 views2 answers
SELECT table_name FROM user_tables;
SQL
0 vote241 views1 answer
Mysql preg replace
SQL
0 vote232 views1 answer
Postgresql certain first 4 characters in string
SQL
0 vote234 views1 answer
Oracle step procedure
SQL
1 vote179 views1 answer
Convert money to varchar sql server
SQL
5 votes231 views1 answer
Mysql change primary key
SQL
-1 vote240 views1 answer
Adding a new table psql
SQL
0 vote295 views1 answer
Reset a table's identity column and remove test records
SQL

Share