Re: [sqlite] Re: A little help with count

Great solution Igor! On 13/01/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote: Lloyd Thomas wrote: > I wish to create a query where I do a number of counts on the same > table but > with different filters. > ie: > count(id) as numrows > count(id) as inrows where direction = 'In' > count(id) as ou

[sqlite] Re: A little help with count

Lloyd Thomas wrote: I wish to create a query where I do a number of counts on the same table but with different filters. ie: count(id) as numrows count(id) as inrows where direction = 'In' count(id) as outrows where direction = 'Out' Could I do the above in a single query? select count(