1..Write an sql query to find the employee name who is having 2 phone numebr?

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?

Question Posted / vgl.mails@gmail.com

4 Answers
11124 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

1..Write an sql query to find the employee name who is having 2 phone numebr? 2.Write an sql quer..

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

1..Write an sql query to find the employee name who is having 2 phone numebr? 2.Write an sql quer..

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

1..Write an sql query to find the employee name who is having 2 phone numebr? 2.Write an sql quer..

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

1..Write an sql query to find the employee name who is having 2 phone numebr? 2.Write an sql quer..

Answer / s kumar

Q1:select Emp_name from Table-Name group by Emp_name having
count(Phone)=2

Hope it'll work out.

Is This Answer Correct ?

3 Yes

3 No

Post New Answer

More RPG400 Interview Questions

HOW TO DELETE THE RECORD FROM MASTER FILE WHICH IS LINK BY ANOTHER TRASATION FILE WITH REFERTIAL INTYGRITY?

1 Answers TCS,

What is the purpose of PUTOVR keyword?

2 Answers

What is the OPEN and CLOSE accesspath?

3 Answers CTS,

How to handle duplicate error handling in RPG?

0 Answers

suppose if we want to update the data in cl what we will do?

9 Answers

1.How to load Records of a Physical file(PF) in the reverse order, in CL program?

2 Answers Cap Gemini,

1.Can any body share me about thease opcodes with example please.Im new for AS/400.Could u please tell me in real senario? 1.TESTN, 2.EVAL 3.EVALR, TIME, 4.MONITOR 5. ENDMON 6.ON-ERROR 7.COMMIT ROLLBACK?

1 Answers CSC,

suppose a job is running for 15 minutes after that it goes to message wait? what are the impact analysis

1 Answers

Hi Viewers can any body explain me how to update and ahange the already existed data in physical file using subfile ? please explain me with the code if possible?

1 Answers

parameters cannot be passed in which one??

2 Answers CTS,

what is *place and *auto keyword in prtf ?plz explain

0 Answers CSC,

1.If *HIVAL SETGT is used what opcode is used to read a record? A:READ B:READPE C:CHAIN D:READP 2.How to pass numeric parameter to the rpg pgm from the command line? 3.What keyword is used on the rpg 4 definition specification to rename a subfile in an externally definition data structure? A:RENAME B;LIKE C:EXTNAME D:EXTFLD

4 Answers Manhattan,

For more RPG400 Interview Questions Click Here