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
- 19065 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
explain about mysql and its features. : Sql dba
How many sql statements are used?
How do you drop a trigger?
Can a foreign key be null?
Explain ddl statements in pl/sql?
What is %type in sql?
How delete all data from table in sql?
What is difference between cursor and trigger?
What does pl sql developer do?
What are the uses of sysdate and user keywords?
What information is needed to connect sql*plus an oracle server?
How to avoid using cursors?
What is the use of double ampersand (&&) in sql queries? Give an example
Explain the commit statement.
What is composite data type in pl sql?
