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
- 9334 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
how do you use commitment control in rpg?
How to write record if no field or the field are different in physical file in rpgle ?
can you debug ile rpg program using isdb?
what are the key words you must use when using a subfile?
can I touch the array during treatments?
We have job which is running as batch. It takes atleast 06 hours to complete tht job. But I wanna do tht job with in 3 hours?
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?
How would display prime numbers using CL program?
what is kids-rpg?
what was the robotech rpg?
How can we know running job is batch or interactive?
Hi Viewers can any body explain me how to update and ahange the already existed data in physical file using subfile ? please explain me with the code if possible?
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
how do I play {insert rpg system here}?
is this a rpg channel?
