[sqlite] How do I get the last item in a list.

[Liz Steel]

I'm doing a select on a table as follows, and I want to get the last item in 
the list. How can I do this without having to step through all of the 
previous items? This may or may not return 100 rows since I cannot be sure 
of the size of the data.

select * from tablename where timestamp < '2003/12/04 12:00:00:000' order by 
timestamp limit 100;

Also, how do I access the archive of messages sent to this list now that 
it's moved from Yahoo?

Thanks,

Liz.

_________________________________________________________________
Find a cheaper internet access deal - choose one to suit you. 
http://www.msn.co.uk/internetaccess

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]