Fetch Latest Entry In table. Last line in database table

Question

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.

Possible duplicate of [Select last row in MySQL](http://stackoverflow.com/questions/4073923/select-last-row-in-mysql) — Billal Begueradj, Jul 03 '16 at 14:10

score 1 · Answer 1 · answered Jul 03 '16 at 14:09

1

Use order by and limit:

select t.*
from t
order by id desc
limit 1;

answered Jul 03 '16 at 14:09

Gordon Linoff

score 1 · Accepted Answer · answered Jul 03 '16 at 14:10

1

use following select query

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

answered Jul 03 '16 at 14:10

Mahesh Madushanka

score 1 · Answer 3 · answered Jul 03 '16 at 14:14

1

Select id, value
  from tablea
order by id desc
limit 1

answered Jul 03 '16 at 14:14

vercelli

3 Answers3