SELECT ABS(SUM(DECODE(ACCOUNTS,'C',AMOUNTS))-SUM(DECODE (ACCOUNT

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 / lalitha

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

Answer Posted / lalitha

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

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does the argument [or replace] do?

1017

What are the syntax and use of the coalesce function?

1105

What does (+) mean in sql joins?

1013

what is the use of set statement in tsql? : Transact sql

945

What is a sql*loader control file?

1165

What is scalar function?

1002

explain primary keys and auto increment fields in mysql : sql dba

902

What are the basic techniques of indexing?

1014

What is a loop in sql?

937

Where not exists in sql?

913

What is sqlite format?

1113

Is nosql relational?

896

What is number function in sql?

915

What is rownum in sql?

967

How can use stored procedures in sql?

1083