On Wed, Sep 17, 2008 at 11:44:38AM +0530, Aravinda babu wrote:

> Is there any easy way to get the last row in the table ?

what do you mean by last?  last by row id?

then

    select * from t1 where oid = (select max(oid) from t1);

should work
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users