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
- 9284 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vaishali zindal
2)select Max(salary)from Employee where salary NOT IN
(select Max (salary)from Emaployee)
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / naga srinivas.kattula
1. select * from filemame phn1 ne ' ' and phm2 ne ' '
Using above query u can get the which employee have 2 phone
numbers
| Is This Answer Correct ? | 1 Yes | 0 No |
suppose one file is used by 100 user and file is locked by 100 user, what are the impact analysis?
I want to declare the number of elements of an array dynamically in RPGLE ? Is it possible? If yes, then how do I do it ?
Hi guys, anybody know How RPG/400 code can be converted to RPG IV code with a single command?
what is post opcode do
this is rpg3 code W0RTN IFEQ @CN,002 what is the means @CN,002
What is the difference between iter and do?
Anyone help me for the below question:- If problem/error occur in *PSSR subroutine,how should I handel it in RPG program.
I have to change a program. This program is calling a subroutine mor than 100times within it. so will it have any performance issue? if yes than what changes i can make. Thanx for ur valuable answer.
Suppose my file has 10 fields and I want to make the 2nd field zeros in all records. And assume I have millions of records and I dont want to read each record and update the desired field with 0. Any other way to do this in one step operation?
if there is a module object , how to find the program object for this module object.Assume the module object name and program object name is not same.
What is the Record Address file. How can we use it in RPG program?
What is significance of a file designated as a Primary file in Rpg400 program....also what's use of secoundry file
RPG400 
