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.
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 sql commands?
how to present a past time in hours, minutes and seconds? : Sql dba
Explain mutating table error.
what is an extent ? : Sql dba
Why we use cross join?
What has stored procedures in sql?
How do I edit a trigger in sql developer?
Explain the the update statement in sql?
What is a trigger in sql?
what is data integrity? : Sql dba
How do you write an inner join query?
What is the difference between the implicit and explicit cursors?
Can a primary key be a foreign key?
How can you fetch first 5 characters of the string?
Why is %isopen always false for an implicit cursor?