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
- 18774 Views
- Ebix, Hewitt, I also Faced
- E-Mail Answers
Answer Posted / umesh naik
select a.amt1 c_sum ,b.amt2 d_sum
, a.amt1 - b.amt2 cd_diffrence
from
(select sum(amount) amt1 from one_table where account='c')
a,
(select sum(amount) amt2 from one_table where account='c') b
select (select sum(a.amount) from one a where
a.account='d')-(select sum(b.amount) from one b where
b.account='c') from dual;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How is a PL/SQL code compiled?
Why do we use sqlite?
What is sql basics?
How to create your own reports in sql developer?
What is difference between pl and sql?
What is difference between function and trigger?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
What are the operators used in select statements?
what is the use of set statement in tsql? : Transact sql
How do I upgrade sql?
Can we rollback after truncate?
Which software is used for pl sql programming?
Is primary key always clustered index?
Why left join is used in sql?
How can we make an if statement within a select statement?
