Select id, eventdate, eventtype, FROM eventlog WHERE eventtype in
('special') order by eventdate desc limit 3
-----Original Message-----
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of deltagam...@gmx.net
Sent: Thursday, November 08, 2012 3:10 PM
To: sqlite-users
Subject: [sqlite] newest 3 entries
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'
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
