/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 vote143 views1 answer
How to add more columns to a table in mysql
SQL
0 vote141 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote138 views1 answer
Mysql cdn link
SQL
5 votes160 views1 answer
Mysql last day of next month
SQL
10 votes149 views6 answers
Between sql
SQL
0 vote143 views1 answer
Mysql query to add hours to column in table
SQL
1 vote93 views1 answer
Metada in sql
SQL
22 votes129 views2 answers
Mysql show all tables
SQL
7 votes142 views2 answers
Html to react converter
SQL
18 votes165 views2 answers
Sql comments
SQL

Share