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 vote282 views1 answer
Mysql isshow
SQL
2 votes229 views1 answer
Sql select in list
SQL
1 vote253 views3 answers
String to int mysql
SQL
0 vote304 views2 answers
Coursera spark sql max count
SQL
16 votes256 views3 answers
Order by sql query
SQL
0 vote301 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
0 vote271 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
1 vote278 views2 answers
Create table if not exist
SQL
1 vote286 views1 answer
How to select the nth row in a SQL database table?
SQL
1 vote277 views1 answer
Oracle stop
SQL