Aravind Rock Aravind Rock - 5 months ago 8
MySQL Question

Fetch Latest Entry In table. Last line in database table

I have a table

tablea

id value
__ _____
1 a
2 b
3 c
4 d
5 e


i want to fetch only latest entry in table (i.e) last value
=>id,value as 5,e

could you please tell me query for this.

Answer

use following select query

SELECT * FROM tablea where ID IN (SELECT MAX(ID) FROM tablea);