How to select the last record of a table in SQL?
Assuming you have an Id column:
SELECT TOP 1 *
FROM table
ORDER
BY Id DESC;
Also, this will work on SQL Server. I think that MySQL you might need to use:
SELECT *
FROM table
ORDER
BY Id DESC
LIMIT 1
But, I'm not 100% sure about this.
EDIT
Looking at the other answers, I'm now 100% confident that I'm correct with the MySQL statement :o)
EDIT
Just seen your latest comment. You could do:
SELECT MAX(Id)
FROM table
This will get you the highest Id number.
to get the last row of a SQL-Database use this sql string:
SELECT * FROM TableName WHERE id=(SELECT max(id) FROM TableName);
Output:
Last Line of your db!
SELECT * FROM TABLE ORDER BY ID DESC LIMIT 1
Yes this is mysql, SQL Server:
SELECT TOP 1 * FROM Table ORDER BY ID DESC
Without any further information, which Database etc the best we can do is something like
Sql Server
SELECT TOP 1 * FROM Table ORDER BY ID DESC
MySql
SELECT * FROM Table ORDER BY ID DESC LIMIT 1