SQL Query [message #2203] |
Thu, 27 June 2002 05:47 |
M.N.Swaminathan
Messages: 10 Registered: May 2002
|
Junior Member |
|
|
Hi,
can anyone give me solution for the below
my table
type_Code emp_code Sanc_Amt Disb_Amt
-------------------------------------
rural x 10 0
urban y 12 6
rural z 15 15
urban a 12 8
i want the output like
type_code ac_sanamt tot_sanc ac_disbamt tot_disb
rural 2 25 1 15
urban 2 24 2 14
rds
Ragavan
|
|
|
|
Re: SQL Query [message #2210 is a reply to message #2203] |
Fri, 28 June 2002 01:59 |
NV
Messages: 6 Registered: June 2002
|
Junior Member |
|
|
hai,
Try with this query :
select type_code,count(type_code),sum(sanc_amt),
count(decode(disb_amt,0,null,disb_amt)) disb_count,
sum(disb_amt) from temp
group by type_code
Hope it will solve ur prob...
Bye
|
|
|