select count(id), "numrows" as type from table
union
select count(id), "inrows" as type from table where direction = 'In'
union
select count(id) as id, "outrows" as type from table where direction = 'Out'
This could be?
I am sorry that i can't try here, because i am not in my work or my home,
and here i don't have SQLite... try and tell if it works or not.
Best Regards
On 13/01/07, Lloyd Thomas <[EMAIL PROTECTED]> 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?
| id | date | direction | duration | cost |
| 1 |2007-01-01|In| 56 | 0.00 |
| 2 |2007-01-01| Out | 60 | 0.10 |
| 3 |2007-01-02| Out | 47 | 0.10 |
| 4 |2007-01-02|In| 120 | 0.20 |
Thx
Lloydie T
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
--
Cesar Rodas
http://www.sf.net/projects/pagerank (The PageRank made easy...)
Mobile Phone: 595 961 974165
Phone: 595 21 645590
[EMAIL PROTECTED]
[EMAIL PROTECTED]