From sqlite-users  Wed Sep 17 06:22:03 2008
From: Chris Wedgwood <cw () f00f ! org>
Date: Wed, 17 Sep 2008 06:22:03 +0000
To: sqlite-users
Subject: Re: [sqlite] Getting the last row
Message-Id: <20080917062203.GA17245 () puku ! stupidest ! org>
X-MARC-Message: https://marc.info/?l=sqlite-users&m=122165356519448

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