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
- 16987 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
What are the different schemas objects that can be created using pl/sql?
Can we use having without group by in sql?
Can we use commit inside a trigger?
Is t sql a programming language?
Is inner join same as self join?
What is time based sql injection?
Is id a reserved word in sql?
What information is needed to connect sql*plus an oracle server?
How many joins in sql?
How to use sql statements in pl/sql?
What are the most important characteristics of pl/sql?
what is a trigger? : Sql dba
Are left and right joins the same?
What is the command used to fetch first 5 characters of the string?
What is hibernate and its relation to sql?
