Mysql get last row

SELECT fields FROM table ORDER BY id DESC LIMIT 1;

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
;

Source: stackoverflow.com

Mysql select last 10 rows

SELECT * FROM tableName ORDER BY col1 DESC LIMIT 10;

How to fetch data from database without last column

SELECT lastName,firstName FROM Customer
       WHERE lastName LIKE "B%"
         AND city = "Indianapolis"
         AND (phone LIKE "%8%" OR fax LIKE "%8%")

Source: dummies.com

Similar codes

0 vote240 views1 answer
Sql statement show all emails with dome
SQL
0 vote249 views1 answer
Postgresql stored procedure update table values
SQL
0 vote207 views1 answer
Lister les index d'une table oracle
SQL
7 votes256 views2 answers
Mysql check db size
SQL
4 votes226 views1 answer
Postgresql change default value
SQL
1 vote223 views1 answer
Add constraint sql
SQL
8 votes244 views1 answer
My sql version
SQL
6 votes230 views4 answers
Delete table sqlite
SQL
1 vote223 views1 answer
User privileges postgresql information_schema
SQL
0 vote219 views1 answer
How to avoid duplicate records in sqlite
SQL