Interested to Buy Any Domain ? << Click Here >> for more details...
in account table
account type amount
ac1 credit 300
ac2 debit 5000
ac3 credit 3000
ac1 debit 4000
ac3 debit 2000
ac2 credit 4000
write a query how to get sum of credit & sum of debit
- 3 Answers
- 5674 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / kamala k n
select type, sum(amount) over (partiton by sid) from tab
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
List out the types of joins.
What is the difference between 10g OEM and 11g OEM?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What is bulk copy or bcp in oracle?
How to create a single index for multiple columns?
Explain a segment?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
How to define an anonymous procedure with variables?
Explain what are the different type of segments?
What is the fastest query method to fetch data from the table?
What are the uses of a database trigger?
What is the maximum number of triggers that can be applied to a single table?
How to add a new column to an existing table in oracle?
What are the different pseudo commands? Explain in general?
