Answers for "how to get last added record in sql"

SQL
4

how to get last row of table in sql

mysql> select *from getLastRecord ORDER BY id DESC LIMIT 1;
Posted by: Guest on June-07-2020
2

get last record in sql

SELECT * FROM TableName WHERE id=(SELECT max(id) FROM TableName);
Posted by: Guest on July-29-2021
0

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%")
Posted by: Guest on November-09-2020

Code answers related to "how to get last added record in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language