gt;>> 1
>>> 1
>>> 1
>>> 4
>>> _
>>> _
>>> 4
>>> _
>>
>> note that "_" means "no data". i want to get a list with [1, 4] as the
>> result. what is the proper SQLite query for this?
You w
> produce approximately 4.4 billion rows and then uses a GROUP BY and COUNT
> to return some values to me.
If your data is somewhat static use aggregate tables which can updated on data
change.
Regards,
Bradley Giesbrecht (pixilla)
___
sqlite-use
nager/
Regards,
Bradley Giesbrecht (pixilla)
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
3 matches
Mail list logo