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 5817Hello 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 6902I 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 11466How 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 13548i was asked to journalise nominal accounts please give me the answer with examples so dat its easy for me 2 understand
3 3952when 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 21999what 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 64691) 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 6676Post New Target Interview Questions
how do I find an smtp mail address in active directory if active directory users and computers tells me it is in use when I try to create a new user
How can I repair my windows 7?
What is indexed view? How to create it?
Can we insert in sql function?
what is the difference between filter and condition?
Can I join my client computer to azure ad as well as on-premises active directory?
What is T’Q and X’Q and X’D ? and what is saturated as well as unsaturated ?
Where mongodb data is stored?
Is android the most popular os?
what is ember.mixin class ?
What is spreadsheet with example?
What are the variables in salesforce?
What are the usages of sql?
What influences will the net of factors (iot) have on transportation quarter?
What is web application and how it works?