Bo Lin wrote:
x,y are both column of Table "aa", they may have random value .And you think that will affect the performance.? What I think is Sqlite will first use "where cluase" to get limitedvalue ,then use "group by" in the same .
Maybe, maybe not. Use EXPLAIN to find out. Igor Tandetnik
