Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 19066 Views
- Ebix, Hewitt, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
what is rollback? : Sql dba
How is a process of pl/sql compiled?
Explain what is an index?
what are the nonstandard string types? : Sql dba
How to fetch the rows by dynamicaly passing table name through cursor?
Why does %isopen return false for an implicit cursor?
In a Distributed Database System Can we execute two queries simultaneously ? Justify ?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What is the use of sqlerrd 3?
What is procedure explain with example?
Does mysql_real_escape_string prevent sql injection?
what is the command line end user interface - mysql? : Sql dba
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
