Re: [sqlite] query 31 days

[Khamis Abuelkomboz]

Khamis Abuelkomboz wrote:

Hi
How many records contain your table? Your select command scans all the 
table entries and I guess that the database uses the standard index. 
try the following command to tell the db which index it should use:

select distinct date from mytable where yearmonth = '200508' order by 
date

Sorry I meen

select distinct date from mytable where yearmonth = '200508' order by 
yearmonth , date