[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]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic