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 |
Delete the emps whose salaries are lowest sals of their own dept.
IF i write before / after insert / update trigger and i do rollback what will happen?
What does pl sql stand for?
What are sql procedures?
What is the use of cursor ? how cursor allocate context area for executing the sql statement?
Do prepared statements prevent sql injection?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
Are sql connections encrypted?
What is trigger in pl sql?
What is not in sql?
Why is a primary key important?
What is pl sql block structure?