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

14 votes288 views2 answers
Oracle limit rows
SQL
15 votes261 views4 answers
How to get all tables in sql
SQL
1 vote293 views1 answer
Psql view enum values
SQL
-2 votes292 views2 answers
Add auto_increment column to existing table mysql
SQL
0 vote249 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote271 views1 answer
Select all columns except one sql
SQL
0 vote251 views1 answer
How to find top 3 salary in sql
SQL
0 vote258 views2 answers
Create new table plsql
SQL
6 votes265 views4 answers
Remove spaces sql server
SQL
1 vote295 views1 answer
Homebrew install mysql
SQL