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

List:       sqlite-users
Subject:    Re: [sqlite] Getting the last row
From:       "Trey Mack" <tmack () factorysystems ! net>
Date:       2008-09-17 6:39:17
Message-ID: 000601c91890$1bf702e0$53e508a0$ () net
[Download RAW message or body]

select * from t order by rowid desc limit 1;

Thanks,
Trey Mack

-----Original Message-----
From: sqlite-users-bounces@sqlite.org
[mailto:sqlite-users-bounces@sqlite.org] On Behalf Of Aravinda babu
Sent: Wednesday, September 17, 2008 2:15 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] Getting the last row

Hi all,

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

Thanks,
Aravind.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

No virus found in this incoming message.
Checked by AVG - http://www.avg.com 
Version: 8.0.169 / Virus Database: 270.6.21/1675 - Release Date: 9/16/2008
7:06 PM

_______________________________________________
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]