/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 vote168 views1 answer
Space not removing from column in sql
SQL
0 vote159 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote148 views1 answer
Mysql cli output to a file
SQL
1 vote146 views1 answer
SQLite order random
SQL
0 vote174 views1 answer
Reset postgresql password windows
SQL
13 votes142 views2 answers
Sqlite rename column
SQL
1 vote175 views1 answer
Drop colum oracle 18c
SQL
0 vote159 views1 answer
Except in sql alchemy
SQL
1 vote136 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote136 views1 answer
Get who is hired in january in sql
SQL

Share