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.
Answers were Sorted based on User's Feedback
Answer / bunty
Hi,
I dont know if this is a intended way for which interviewer
has asked, but it will definitely give an answer,
select (select sum(value) from test_tab where parent='D')-
(select sum(value) from test_tab where parent='C')
difference from dual;
Cheers,
Bunty
Is This Answer Correct ? | 13 Yes | 2 No |
Answer / biswaranjan
this works good for the query
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 ? | 11 Yes | 1 No |
Answer / anuj shukla
Hi all,
question simply ask for the total of both the columns and
their difference, all in one 'select' statement.
select sum(c)"Sum of C",sum(d)"Sum Of
D",abs(sum(c)-sum(d))"Difference" from accountA
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / lalitha
SELECT ABS(SUM(DECODE(ACCOUNTS,'C',AMOUNTS))-SUM(DECODE
(ACCOUNTS,'D',AMOUNTS))) FROM TEMP
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / akki julak
SELECT SUM(C),SUM(D),SUM(C)-SUM(D) 'difference'
FROM accounts;
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / priya
The question is not in proper grammar .. To me it looks like
what Biswaranjan interprets above
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / 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 |
Answer / vijay sinha
select (select sum(amount) from table_name where account = 'C') - (select sum(amount) from table_name where account = 'D')
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / ankur maheshwari
select abs(sum(c1.amounts)-sum(d1.amounts)) 'Amount
difference' from account c1, account d1 where
c1.accounts='c' and d1.accounts='d'
Is This Answer Correct ? | 1 Yes | 2 No |
Is sql a scripting language?
Does sql*plus have a pl/sql engine?
what is sql server agent? : Sql dba
What is sql engine in oracle?
Where is sql database stored?
What is normalization? How many normalization forms are there?
What do we need to check in database testing?
What is procedure and function?
What are the usage of SAVEPOINTS?
Why left join is used in sql?
How can I speed up sql query?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba