/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

18 votes209 views3 answers
Find column name in database
SQL
0 vote198 views1 answer
Oracle sql date winter time
SQL
0 vote228 views1 answer
How do I insert a blob in SQL?
SQL
1 vote198 views1 answer
Varchar plsql
SQL
1 vote210 views3 answers
Connect to mysql c# connection string C#
SQL
5 votes194 views1 answer
Oracle generate list of dates in between a date range
SQL
45 votes234 views5 answers
Grant all privileges mysql
SQL
0 vote204 views2 answers
Plsql function that return a table
SQL
3 votes210 views2 answers
Postgres show table schema
SQL
0 vote203 views1 answer
Set column width in sqlplus
SQL

Share