/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

3 votes100 views1 answer
Insert into table from another table mysql
SQL
0 vote63 views1 answer
Sql count how many times a value appears
SQL
4 votes113 views1 answer
Mysql delete last row
SQL
1 vote94 views1 answer
Postgres get month name from date
SQL
0 vote109 views1 answer
Psql get table data types
SQL
6 votes99 views5 answers
Alter table oracle
SQL
42 votes174 views6 answers
Install beautifulsoup
SQL
0 vote118 views2 answers
Impala rename column name
SQL
1 vote121 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
-1 vote100 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL

Share