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.
- 11 Answers
- 16996 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
What is primary key and foreign key with example?
Can we insert data into view?
Explain the purpose of %type and %rowtype data types?
Does sql use python?
give the syntax of grant and revoke commands? : Sql dba
Can a procedure in a package be overloaded?
What are different types of keys?
Mention what is the use of function "module procedure" in pl/sql?
Is drop table faster than truncate?
What is a table partition?
What is string data type in sql?
Define join and name different types of joins?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
Will truncate release space?
What is exit statement?
