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 / sandeep
I hope this will be helpful.
SELECT sum(Account) as "Account Sum", sum(Amount) as "Amount
Sum", sum(Amount)-sum(Account) as "Difference" FROM account
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
what is the difference between a web-garden and a web-farm? : Sql dba
What is the max nvarchar size?
Enlist the advantages of sql.
Which table is left in join?
Can instead of triggers be used to fire once for each statement on a view?
Can we join 3 tables in sql?
What is left join example?
Is sql an operating system?
how do you control the max size of a heap table? : Sql dba
What is difference between mysql and postgresql?
What is number function in sql?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What does trigger mean in slang?
What is procedure in pl sql?
How are functions and procedures called in PL/SQL?