/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

-1 vote191 views1 answer
Sql getdate date only
SQL
1 vote223 views5 answers
What is in operator in sql
SQL
0 vote155 views1 answer
How to see the content of tables in pgadmin
SQL
1 vote211 views1 answer
Mysql f# examples
SQL
8 votes186 views1 answer
Oracle add month
SQL
7 votes224 views2 answers
Postgres concat
SQL
0 vote198 views1 answer
Sql server 2012 create or alter procedure
SQL
0 vote236 views1 answer
Add new column in sql with foreign key
SQL
6 votes250 views2 answers
How to get last element sql
SQL
8 votes259 views4 answers
Postgresql server restart
SQL

Share