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 vote269 views1 answer
Sqlalchemy empty table
SQL
0 vote267 views1 answer
Group by two columns postgres
SQL
0 vote267 views1 answer
Sql join on a subquery
SQL
104 votes417 views2 answers
Like in mysql
SQL
1 vote262 views1 answer
Data type and their numeric form
SQL
6 votes245 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
13 votes433 views4 answers
Sql joining 3 tables
SQL
0 vote293 views1 answer
Virtuoso sql query tutorial
SQL
0 vote261 views1 answer
How to input data as id in database sql c#
SQL
2 votes272 views3 answers
Sql interview query questions
SQL