[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] Getting the last row
From:       Chris Wedgwood <cw () f00f ! org>
Date:       2008-09-17 6:22:03
Message-ID: 20080917062203.GA17245 () puku ! stupidest ! org
[Download RAW message or body]

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
[prev in list] [next in list] [prev in thread] [next in thread]