Am 08.11.2012 21:17, schrieb Igor Tandetnik:
On 11/8/2012 3:10 PM, deltagam...@gmx.net wrote:
I have a select statement like:
"Select id, eventdate, eventtype, FROM eventlog WHERE eventtype in
('special') "
Now I like to receive only the newest 3 entries in the table eventlog
where the eventtype is 'special'
select id, eventdate, eventtype FROM eventlog WHERE eventtype in
('special')
order by eventdate desc limit 3;
Yes, thx Igor, I got it too now, long time that I was occupied with
sqlite ;)
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users