select abs(sum(c1.amounts)-sum(d1.amounts)) 'Amount difference'

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 / ankur maheshwari

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are tables and fields in the database?

1022

How to Declare Fixed Length String Value In PL SQL

1101

What is db journal file?

956

How many types of tables are there?

899

What is the difference between the implicit and explicit cursors?

990

what is offset-fetch filter in tsql? : Transact sql

890

What is dynamic sql in pl sql?

979

What is primary key and foreign key with example?

870

List the different type of joins?

997

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

967

How many joins can you have in sql?

880

What are the types of views in sql?

1038

What is pl sql variable?

934

Why do we need cursors in pl sql?

1000

Why do we need pl sql?

934