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