Re: Multiple counts

[Quoted] "ciccio" <ciccio_at_ciccio.it> a écrit dans le message de news:423b0488_1_at_x-privat.org...
| Hi,
|
| I'd like to write a query that returns a series of count(*) horizontally.
|
| Pratically, if I have such a table:
|
| Name Amount Category
| ------------------------
| John 1000 1
| Jim 1500 2
| Mary 750 1
| George 2000 2
| Melanie 3000 2
|
| I'd like to do like this:
|
| SELECT COUNT(*) AS CAT1 FROM MYTABLE WHERE CATEGORY = 1, SELECT COUNT(*)
| AS CAT2 FROM MYTABLE WHERE CATEGORY = 2
|
| in order to obtain:
|
| CAT1 CAT2
| ------------
| 2 3
|
| That is what I need. How can I rewrite the query (the one above of
| course doesn't work) in order to obtain this result?
|
| Thanks

select sum(decode(category,1,1,0)) cat1, sum(decode(category,2,1,0)) cat2 from mytable;

Regards
Michel Cadot Received on Fri Mar 18 2005 - 17:46:47 CET