[sqlite] Re: 回复： [sqlite] Re: About Index using

[Igor Tandetnik]

Bo Lin <blin_beijing-/[EMAIL PROTECTED]> wrote:

I just found a strange case , can you give me some explaination ?

The Sql looks like
   select x, y, sum(z)/1000 as bw from aa where
       a=1 and b=1 and

c =1 and d= 6 group by x, y having count(*) > 1 order by bw desc limit 10

Column "d" is all set to 6
1/3 of total  record is (a=1,b=1,c=1)
1/3 of total  record is (a=2,b=2,c=2)
1/3 of total  record is (a=3,b=3,c=3)

Where do x and y come from, what are their values?

Igor Tandetnik