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
- 15884 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
Does sql full backup truncate logs?
what is the difference between delete and truncate commands? : Sql dba
what is a composite primary key ? : Sql dba
How to get unique records from a table?
What are the disadvantages of file system?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
What are % type and % rowtype?
What is sql exception?
how to enter characters as hex numbers? : Sql dba
What is meant by <> in sql?
How can I get the number of records affected by a stored procedure?
What is right join sql?
How many primary keys can a table have?
What will you get by the cursor attribute sql%notfound?
What do you understand by pl/sql packages?
