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
- 15881 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 a sql schema used for?
What is package in pl sql?
What is the usage of sql functions?
Is vs as in pl sql?
What is sql and also describe types of sql statements?
What are the sql versions?
What is the difference between partition and index?
How does stored procedure reduce network traffic?
Explain mutating table error.
What is trigger in sql and its types?
What are the sql commands?
How to get unique records from a table?
What are the topics in pl sql?
Does sqlite need a server?
What is trigger in pl sql with examples?
