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

7 votes139 views3 answers
Foreign key oracle
SQL
0 vote123 views2 answers
Postgresql change user role grant
SQL
0 vote159 views1 answer
Sql order by number not ordered
SQL
24 votes120 views2 answers
Alter table delete column
SQL
3 votes154 views5 answers
Foreign keys
SQL
0 vote132 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
6 votes134 views3 answers
Commit in sql
SQL
0 vote142 views1 answer
Codigo crear tablas sql server
SQL
2 votes121 views2 answers
How to create an empty table from an existing table
SQL
0 vote173 views1 answer
Drop a view in sqlite
SQL