Re: Help needed on sql query!

"desi99" <kdjain_at_gmail.com> a écrit dans le message de news:1111509657.838848.31560_at_z14g2000cwz.googlegroups.com...
| Hi,
| I am stiuck on this query and will appreciate any help.
| Here is my table-
| city region issue value
| c1 north i1 y
| c1 north i2 y
| c2 north i1 n
| c2 north i2 y
| c3 south i1 y
| c3 south i2 n
| c4 east i1 n
| c4 east i2 n
|
| This table consist of value for every issue(yes/no) for every city.
| I am trying to create a report whihc looks like this
| This report counts # of yes for every issue in a region,
|
| region issue count(yes)
| north i1 2
| north i2 1
| south i1 1
| south i2 0
| east i1 0
| east i2 0
|
| Please help!
|

http://oraclesvca2.oracle.com/docs/cd/B10501_01/server.920/a96540/functions26a.htm http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_103a.htm#2066420

Regards
Michel Cadot Received on Tue Mar 22 2005 - 11:10:43 CST