Interested to Buy Any Domain ? << Click Here >> for more details...
1..Write an sql query to find the employee name who is
having 2 phone numebr?
2.Write an sql query to the the second highest salary of
the employee?
- 4 Answers
- 10772 Views
- I also Faced
- E-Mail Answers
Answer Posted / raj
Q1:
Q2: select max(SAL) from EMP_TAB where SAL < (select max
(SAL) from EMP_TAB
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Explain mdt?
Assume 2 users are using the same file and first user updates some record in the file. Will the 2nd user will be able to see the updated record or not?
Set on command is used for closed all opened files , initialize var and release resource , return cmd is used for return to calling program but my req. Is dnt close opened files and resource must released while doing transactions , how can i do this...?
1. What is bound-by-call and bound-by-reference? 2. Where and why is *Nomain used? 3. What are the difficulties faced by programmers when using service programs? 4. Explain the different ways of parsing and compiling XML in iSeries.
When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?
give an eg of ACQ-(ACQUIRE),BIT OFF,BIT ON,DEALLOC,DUMP,FEOD,FORCE,MHHZO,MHLZO,MHLLZO,MLHZO,REL,RESET,TESTZ,TESTB,TESTN----GIVE SMALL EXAMPLE TO THE OPCODES...TO UNDERSTAND FUNCTIONING...........
What is the difference between iter and do?
how do I preserve and clean the array?
What is the difference between copybooks and subprocedures in as400?
How to write record if no field or the field are different in physical file in rpgle ?
what is the difference between do while and do until?
do you use message subfiles? What are the necessary keywords required coding a message subfile?
what is the necessary keyword needed to scroll subfile records?
If my rpg program has a date field, what extra care I have to take while compiling that rpg program? If the file is keyed and I have declared the file as well as key list properly in my program. Still am getting an error message like "chain/reade operation is not allowed" what may be the case?
How to handle duplicate error handling in RPG?
