Re: [sqlite] newest 3 entries

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 i

Re: [sqlite] newest 3 entries

On Thu, Nov 8, 2012 at 10:17 PM, Igor Tandetnik wrote: > 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

Re: [sqlite] newest 3 entries

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

Re: [sqlite] newest 3 entries

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,

[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