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

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts wit..

Hi,
I dont know if this is a intended way for which interviewer

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

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts wit..

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

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts wit..

SELECT SUM(C)-SUM(D) FROM TABLE_NAME;

 Is This Answer Correct ? 8 Yes 6 No

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts wit..

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

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts wit..

SELECT ABS(SUM(DECODE(ACCOUNTS,'C',AMOUNTS))-SUM(DECODE
(ACCOUNTS,'D',AMOUNTS))) FROM TEMP

 Is This Answer Correct ? 2 Yes 2 No

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts wit..

SELECT SUM(C),SUM(D),SUM(C)-SUM(D) 'difference'
FROM accounts;

 Is This Answer Correct ? 3 Yes 3 No

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts wit..

The question is not in proper grammar .. To me it looks like
what Biswaranjan interprets above

 Is This Answer Correct ? 0 Yes 1 No

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts wit..

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

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts wit..

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

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts wit..

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

More SQL PLSQL Interview Questions

What is sqlite used for?

What is the use of partition by in sql?

What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

Explain table and field in sql?

Enlist the characteristics of pl/sql?

What is not null in sql?

What is a common use of group by in sql?

How to add Foreign key in a table after the creation of the table?

What are the different types of sql commands?

what is a materialized view? : Sql dba

Is sql an operating system?

full outer join syntax

Categories
• Oracle (3238)
• SQL Server (4518)
• MS Access (429)
• MySQL (1385)
• Postgre (483)
• Sybase (267)
• DB Architecture (141)
• DB Administration (291)
• DB Development (113)
• SQL PLSQL (3300)
• MongoDB (502)
• IBM Informix (50)
• Neo4j (82)
• InfluxDB (0)
• Apache CouchDB (44)
• Firebird (5)
• Database Management (1391)
• Databases AllOther (288)