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
- 9380 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
thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400
how do I play {insert rpg system here}?
what is an online rpg?
how do I declare a minor?
what is *place and *auto keyword in prtf ?plz explain
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 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...
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?
what are the key words you must use when using a subfile?
what is the necessary keyword needed to scroll subfile records?
what is a rpg?
Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg
What is the difference between copybooks and subprocedures in as400?
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?
What is file identifier where we can use?
