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 7474I 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 12232How 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 14042i was asked to journalise nominal accounts please give me the answer with examples so dat its easy for me 2 understand
3 4712when 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 22790what 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 71151) 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 6990Post 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)
Define say() function in perl?
Why do you want to work for BPO company
how fast can you learn things?
How do I find the #value in excel?
what conceptual model helps provide an understanding of how network protocol stacks such as tcp/ip work? : Windows server 2008
How to protect your website from sql injection in zend using select query?
Does magnetomonopoles exists? one maxwell equation strongly suggests no, but how about their existance in plasma?
explain the application of a jfet.
Name the different file types available with unix.
Write a C/C++ program that connects to a MySQL server and checks if the InnoDB plug-in is installed on it. If so, your program should print the maximum number of concurrent threads that the InnoDB plug-in can create
What port is mysql running on?
What is a simple graph?
how many edges are there in 3d cube, 4d cube and 2d cube?(Puzzle based questions)
What is semantic caching, and how does it improve LLM app performance?
What is the use of drop command?
