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
What are the types of identifiers?
Explain mdt?
how can you display specific subfile page on the screen in unequal subfile?
can any one help in hawkeye and turnover or any change management system plzzzzz or send the documents to my mail id :gvsp.as4@gmail.com
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
When it is desirable to describe files Internally?
How to declare the pull button in AS/400..
1. If there are two programs using same file and 2 users are using the file at the same time and what can be done to allow them both to access? 2. How can remove lock from the file for accessing it by both users?
What is the difference between iter and do?
How Chain operation copies the record's data to the input buffer for the program?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
How to handle duplicate error handling in RPG?
what is the use of sflnxtchg?
Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg
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...........