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
- 15815 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
Does view store data in sql?
How many types of primary keys are there?
What is online transaction processing (oltp)?
Which is better stored procedure or query?
what is rdbms? : Sql dba
Is it possible to include an insert statement on the same table to which the trigger is assigned?
What is query syntax?
What are the two types of exceptions in pl/sql?
what is the difference between truncate and drop statements? : Sql dba
Can a view be mutating? If yes, then how?
what is primary key? : Sql dba
Is primary key a clustered index?
Can we change the table name in sql?
Can cursors be part of a trigger body?
What is the difference between join and natural join?
