select a.amt1 c_sum ,b.amt2 d_sum , a.amt1 - b.amt2 cd

i have one table with accounts and amounts as
colums.accounts with columns c and d. and amounts with
values 1000,2000,3000 for c and 4000,5000,8000 for d.i need
to find the sum of these accounts c and d individually
and find the differences between their sum using one select
statement.

Question Posted / umesh naik

11 Answers
19050 Views
Ebix, Hewitt, I also Faced
E-Mail Answers

Answer Posted / umesh naik

select a.amt1 c_sum ,b.amt2 d_sum
, a.amt1 - b.amt2 cd_diffrence
from
(select sum(amount) amt1 from one_table where account='c')
a,
(select sum(amount) amt2 from one_table where account='c') b

select (select sum(a.amount) from one a where
a.account='d')-(select sum(b.amount) from one b where
b.account='c') from dual;

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sharding in sql?

1041

What is sqlerrm?

987

How do you change a value in sql?

1069

How do I debug a stored procedure?

1171

What is cascade in sql?

1017

What is %rowtype in pl sql?

1032

what is csv? : Sql dba

1051

What can you do with pl sql?

1146

what are aggregate and scalar functions? : Sql dba

1110

How much does sql certification cost?

1142

What are field types?

1055

Is primary key clustered or nonclustered?

1063

Define a temp table?

1082

Explain the update statement in sql

1046

What is compute?

1152