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
- 15813 Views
- Ebix, Hewitt, I also Faced
- E-Mail Answers
Answer Posted / apurba
SELECT SUM(C)-SUM(D) FROM TABLE_NAME;
| Is This Answer Correct ? | 8 Yes | 6 No |
Post New Answer View All Answers
How to select unique records from a table?
How much does sql certification cost?
What is the unique index?
What is nosql vs sql?
What is assignment operator in pl sql?
what is oracle database ? : Sql dba
What is delimiter sql?
What is an inner join sql?
Does truncate remove indexes?
what are properties of a transaction? : Sql dba
What is natural join in sql?
What is on delete restrict?
Is there a way to automate sql execution from the command-line, batch job or shell script?
What is union?
What are expressions?
