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 / 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 the difference between copybooks and subprocedures in as400?
What are the types of identifiers?
How to call one program from another program in RPG? please help me with the code
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?
How can we override a file during runtime in rpg?
How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...
What is difference between bind by copy and bind by reference?
what is the procedure and explain about real time scenario.
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
what is the rpg system?
how can I tell when to replace the array?
how do you use commitment control in rpg?
is this a rpg channel?
what is file information data structure?
what do you mean by an input subfile, what are the keywords required?