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 6399Hello 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 7484I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can i do it and drag it onto report editor.
6 12237How we can code in a jcl to execute a job in a particular time and date without using any job shudular?. (Eg) i want to execute a particular job at 8 am on 01/01/2010.
2 14043i was asked to journalise nominal accounts please give me the answer with examples so dat its easy for me 2 understand
3 4726when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....
4 22800what is the drawback of vsam dataset?? a.execution slow. b.free space. c.independent storage device. d.none of the above. let me know the answer with reason.
4 71211) I have 5000 test cases within 3 working days u have to finish? How you will handle it. 2) Difference between Relase-1 and Relase-2
1 6995Post New Target 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)
Why linux is more secure?
What is reverse engineering in hibernate?
What are aggregated objects
Can I authenticate with client certificates configured in sap cloud platform destinations at http services that are exposed via the cloud connector?
List the type of locks?
What is a byte array?
For amonia manufacturing process if pressure, temperature would be increase over optimum level what would be happen?And what steps should be taken?
Is flask or django better?
Can we define our own match code id's for sap matchcodes? : abap data dictionary
What is a brain freeze?
Why mineral oil or light liquid paraffin is used for ir analysis
What function are arguments available to express js route handlers?
Differentiate between validation and substitution
How do I search a whole word in vim?
what is the exact heat treatment cycle of IS 4522 Gr6 to get the required properties?
