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?
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 can we know running job is batch or interactive?
What is difference between bind by copy and bind by reference?
what do you mean by an input subfile, what are the keywords required?
how do I play {insert rpg system here}?
how do I declare a minor?
what is a rpg?
Interviewer asked me write down DDS for load all subfile .can anybody write dds
How would display prime numbers using CL program?
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.
is this a rpg channel?
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...?
How Chain operation copies the record's data to the input buffer for the program?
What is file identifier where we can use?
How can we override a file during runtime in rpg?
How to write record if no field or the field are different in physical file in rpgle ?