Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10984 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / naga srinivas.kattula
1. select * from filemame phn1 ne ' ' and phm2 ne ' '
Using above query u can get the which employee have 2 phone
numbers
| Is This Answer Correct ? | 1 Yes | 0 No |
How to select highest score of each subject or how to select highest income of every month?
In single page subfile,if I select the mutiple options in 1 page and without pressing enter,I press rollup key (pagedown).In such case how I can handle it in rpg becasue in single page we have to handle it in pgm. It would be helpful if any one answer with coding
4 Answers Infinite Computer Solutions,
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 the difference between SETON RT & RETURN?
Suppose i am having 3 programs PgmA,pgmB,pgmC and using source debugger. At debugging time i found that pgmC having some code error..then in debug mode directly how can i debug pgmC
What is the name of default out queue when user logs inn to syatem with valid profile?
Q:Hi all,i want accurate answer with code using in built functions.please sent me code as soon as posible. I have program nmed PGM1 which '' RETRIEVE Current production date''should correctly default the production date for the user who is issuing raw materials to the manufacturing.The production date can be different from the celendra date. However, the program does not make the correct adjustment for all manufacturing plants. there is a parameter which determines the production start time e.g. 07:00 if the system time precedes this,the program subtracts one from the celendra day.This work fine when the celendar day starts after production day as it does in England,the system should be adding one to the celendar day during the overlap. unfortunately the program was desined to assumed the celendar day always starts before the production day. Change required in the program: Change the PROGRAM PGM1 to use the new parrameter to decide whether to add or subtract 1 from the celendar day when determining the production date.
What are the values of NUM1 and NUM2 after executing the following code? CLONO1NO2NO3 Factorl÷÷+OpcdeFactor2+÷+ResultLenDHHiLoEq C MOVE *LOVAL NUM1 50 C MOVE *J-fIVAL NtJM2 52
Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg
Why we need to give File and To file Names While we are using OVRDBF. What is your understanding related to this?
Why Rpg/400 is Famous?
why we do STRSRVJOB in batch debugging in as400
RPG400 
