lundi 26 mai 2014

Select last inserted row for specific column id


Vote count:

0




I have table t1.


id name surname last_updated


1 ABC XYZ 2014-05-26 14:35:14


2 ABC XYZ 2014-05-26 15:35:14


3 LMN SDF 2014-05-25 14:35:14


4 PQR DFG 2014-05-24 14:35:14


I want record of row where name = ABC, but last_updated time= last inserted for ABC ..


Thanx in advance...


Prashant.



asked 19 secs ago






Aucun commentaire:

Enregistrer un commentaire