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
- 17013 Views
- Ebix, Hewitt, I also Faced
- E-Mail Answers
Answer Posted / anuj shukla
Hi all,
question simply ask for the total of both the columns and
their difference, all in one 'select' statement.
select sum(c)"Sum of C",sum(d)"Sum Of
D",abs(sum(c)-sum(d))"Difference" from accountA
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Which are sql * plus commands?
Why do we go for stored procedures?
What is numeric function sql?
Why we use cross join?
What are pl sql data types?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
What is the difference between functions, procedures, and packages in pl/sql?
What do you think about pl/sql?
Is sql a dbms?
What is a unique constraint?
Is foreign key mandatory?
Which is faster joins or subqueries?
Mention what does plv msg allows you to do?
Can we change the table name in sql?
What is procedure function?
