select * from t order by rowid desc limit 1; Thanks, Trey Mack
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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
