select last record in sql code example
Example 1: how to get last row of table in sql
mysql> select *from getLastRecord ORDER BY id DESC LIMIT 1;
Example 2: Select last row from SQL Table
SELECT * FROM TableName WHERE id=(SELECT max(id) FROM TableName);
Example 3: 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%")