Re: complex query please help [message #21590] |
Fri, 16 August 2002 00:49 |
mani
Messages: 105 Registered: September 1999
|
Senior Member |
|
|
Hi,
As for as my knowledge i have written this.
select aa.region,
reg_cnt.cnt,
amt_cnt.cnt1
from
aa,
(select region,count(region) cnt from aa a1 where a1.region = region group by region) reg_cnt ,
(select region,count(amount) cnt1 from aa a2 where a2.amount= 0 and a2.region = region group by region) amt_cnt
where
aa.region = reg_cnt.region
and aa.region = amt_cnt.region
group by aa.region,cnt,cnt1
Regards
Mani
|
|
|