/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 vote360 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
0 vote338 views1 answer
Wp_query raw sql
SQL
0 vote314 views1 answer
Mysql_num_fields in mysqli
SQL
0 vote358 views1 answer
Postgres foreign key multiple columns
SQL
20 votes326 views3 answers
SQL query rename table
SQL
0 vote345 views1 answer
Postgres get database encoding
SQL
0 vote328 views1 answer
How many rows affected in sqllite
SQL
2 votes347 views1 answer
Sql server check for value in multiple columns
SQL
0 vote332 views1 answer
Como hacer una consulta en sql
SQL
0 vote309 views1 answer
Mysql update sequence with order by
SQL

Share