On Thu, Nov 8, 2012 at 10:17 PM, Igor Tandetnik <itandet...@mvps.org> 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 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;
>
I'm guessing that "WHERE eventtype = 'special' " is more efficient then
"WHERE eventtype in ('special') "
Just a guess.
--
˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
