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 5804Hello 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 6875I 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 11439How 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 13533i was asked to journalise nominal accounts please give me the answer with examples so dat its easy for me 2 understand
3 3932when 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 21973what 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 64571) 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 6672Post 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)
Give 3 scenario of reporting due to which you require reporting help of ABAP consultant?
What is the use of a pseudo class?
What is verbatim literal in c#?
If a transformer primary winding operates at 240v, the secondary at 120v and the load is 1500w & the transformer is rated at 92% efficient, what's the current flowing through the primary winding of the transformer? What is the formula for finding this?
What is the benefit of spring boot? : Spring Boot
What are the different access modifiers available in java?
Explain about servertype directive in apache server?
How many search tools are available in the search area of the organization and staffing interface?
being an electrical engineer why you wanna come into software i have an very good academics what answer i have to give
What does ‘jps’ command do?
Does quality score matter?
Explain what is an interface in c#?
What is the use of option explicit in vbscript?
How to combine multiple order in one Delivery ( Step by Step)?
What is aidl? What are the datatypes supported by aidl?
