On Sat, Jan 29, 2011 at 01:03:05PM -0800, Marian Cascaval wrote:
> Here's the info source on LAST() function:
>
> http://www.w3schools.com/sql/sql_func_last.asp
>
>
>
> I needed to retrieve the last row from a table.
If you need the "last row from a table" that's trivial to do efficiently
in SQLite3:
SELECT ... FROM ... ORDER BY rowid DESC LIMIT 1;
(You should, but don't have to, replace rowid with whatever the INTEGER
PRIMARY KEY column is, if there is one.)
Nico
--
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
