Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance
5 6387Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy
6 7474Post New Target SQL PLSQL Interview Questions
- Target C Sharp Interview Questions (1)
- Target Crystal Reports Interview Questions (3) Target SQL PLSQL Interview Questions (2)
- Target Manual Testing Interview Questions (4)
- Target JCL Interview Questions (1)
- Target DB2 Interview Questions (1)
- Target VSAM Interview Questions (1)
- Target Business Objects Interview Questions (1)
- Target Cognos Interview Questions (3)
- Target Informatica Interview Questions (3)
- Target Data Stage Interview Questions (1)
- Target Micro Strategy Interview Questions (1)
- Target Data Warehouse General Interview Questions (1)
- Target Civil Engineering Interview Questions (1)
- Target Engineering AllOther Interview Questions (1)
- Target Marketing Sales Interview Questions (1)
- Target Business Management AllOther Interview Questions (1)
- Target Accounting AllOther Interview Questions (1)
- Target Call Centre AllOther Interview Questions (1)
Explain serialization?
How do I split a cell horizontally in excel?
Explain importance of throws keyword in java?
what are the advantages of using a voltage follower amplifier?
What are the types of pump can be found in the engine room
What are the electro cardiogram findings of a mobitz type ii second degree av block?
what is frame structher in SDH .
hi all I got two exam call letter one from maha ganeco & other from federal bank both at same time & same date which should i choose (note I am eng. grad.)
When servlet is loaded?
What’s the mod_perl module?
Explain about consistent programming model in the .NET framework?
What is a congested switch?
How do I find where an app is installed?
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
What is the purpose of managed object context (nsmanagedobjectcontext) in objective-c and how does it work?
