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
- 18308 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 is indexing oracle sql?
How do you write an inner join query?
What are string functions in sql?
What is basic structure of pl sql?
How do you delete data from a table?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What is dense_rank?
what are the difference between clustered and a non-clustered index? : Sql dba
How to get list of all tables from a database?
How to create an array in pl/sql?
What is data profiling in sql?
Is a foreign key always unique?
how to install mysql? : Sql dba
What are predefined functions in sql?
Why we use joins in sql?
