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
- 11119 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
What is a record lock error?
what is *place and *auto keyword in prtf ?plz explain
what is an online rpg?
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
what was the robotech rpg?
is this a rpg channel?
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...........
How do u design a physical file, when you have 2 Unique fields like for eg in A student file student ID and student examination no both are unique
What is file identifier where we can use?
can anybody help me to solve this problem. the program that i m checking display error message saying "Record format for file AJDSPFFD does not match model file and decimal error. how to solve this problem. The AJDSPFFD is snapshot the AJTLOG that is the audit trail list.
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.
what is file information data structure?
explain sflclr, sflend, sfldlt, and sflcsrrrn?
what is program status data structure?
How to select highest score of each subject or how to select highest income of every month?
