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 / 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 to disable a trigger name update_salary?
Why we use stored procedure instead of query?
write an sql query to find names of employee start with 'a'? : Sql dba
What are the two virtual tables available at the time of database trigger execution?
What is sp_helptext?
Explain character-manipulation functions?
How can triggers be used for the table auditing?
What do you understand by pl/sql records?
What is the need of a partition key?
What are the types pl/sql code blocks?
What is the largest value that can be stored in a byte data field?
How we can update the view?
How can we implement rollback or commit statement in a trigger?
Is full outer join same as cross join?
What is the difference between microsoft sql and mysql?