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
- 16989 Views
- Ebix, Hewitt, I also Faced
- E-Mail Answers
Answer Posted / akki julak
SELECT SUM(C),SUM(D),SUM(C)-SUM(D) 'difference'
FROM accounts;
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
How many types of cursors supported in pl/sql?
Why do we use joins?
explain normalization concept? : Sql dba
What is the difference between cluster and non-cluster index?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
How many sql statements are used? Define them.
Can a composite key be null?
Determine if oracle date is on a weekend?
What are the types of join and explain each?
What is multiple partition?
What type of join is sql join?
Is sql harder than python?
What is sql in java?
What are character functions?
how many sql dml commands are supported by 'mysql'? : Sql dba
