Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 18759 Views
- Ebix, Hewitt, I also Faced
- E-Mail Answers
Answer Posted / sandeep
I hope this will be helpful.
SELECT sum(Account) as "Account Sum", sum(Amount) as "Amount
Sum", sum(Amount)-sum(Account) as "Difference" FROM account
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are inner outer left and right joins in sql?
Is sql considered coding?
What do you mean by field in sql?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
Why is sharding used?
What is restrict in sql?
What is the difference between stored procedure and view?
How can I delete duplicate rows?
How do I save a stored procedure?
Difference between truncate, delete and drop commands?
Name three sql operations that perform a sort.
What do we need to check in database testing?
Why trigger is used in sql?
What is trigger in flip flop?
What is case function?
