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
10998 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 find whether a date format is valid or not in RPG400 not in RPGILE.Can you please write the coding for this sir,i'm new to AS400.Please help.

2 Answers iGate,

How Chain operation copies the record's data to the input buffer for the program?

0 Answers IBM,

What are the commands that can be executed in CLP but not in RPG? Why?

1 Answers CSC,

Can more than one subfile record be displayed on one line?

7 Answers IBM,

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,

1.Load an runtime array of length 99 from the pf and you want to handle all the possible errors?

1 Answers HCL,

How can we override a file during runtime in rpg?

0 Answers

Can you copy the records created by the OPNQRYF to other files and how?

2 Answers

Q1.How we can copy the data of file one session to another session? Q2.how we can execute a loop infinitely in AS/400 coding? Q3.In ALDON tool,multitask is posible on a perticular object by the user?

6 Answers CSC,

what will happen two jobs have same name are submitted

5 Answers CTS,

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?

0 Answers

Can a indexed file be accessed in arrival sequence in RPG?

1 Answers

For more RPG400 Interview Questions Click Here