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
10844 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

what is estimation? and what is the level identifier parameter in PF?

3 Answers TCS,

The PGMA calls PGMB.PGMB generates a report.The report should contain the called program name(PGMA).How do i get the called program name in PGMB to print it on the spool file?(calling program name should NOT be hard coded or passed as parameter to called program?

6 Answers

how do u find whether a record is locked or not??

4 Answers CTS,

Have a join logical file with more than one members with different record formats. So how can we read the different members from this file and also how we can read the different record format from the join logical?

3 Answers

How do I link an existing logical file to it's Physical File without recompiling?

2 Answers

I want to declare the number of elements of an array dynamically in RPGLE ? Is it possible? If yes, then how do I do it ?

2 Answers

wat is the difference between dataarea and data queue?

5 Answers Airtel, Four soft, Shahi Exports,

How to find d key field of a pf that doesn’t have source physical file?

2 Answers

In a particular program one file is used where override command is applied to a file, now this program calls another program where we want to use the same file but without override.How it can be done?

6 Answers Hexaware,

I want my simple Green screen should refersh every 1 min ,How can I do it..? Please share the logic

2 Answers

I know chain keyword retreive records randomly but how chain keyword exactly works internally????

4 Answers

Errors in Sql query will be in which state?

1 Answers

For more RPG400 Interview Questions Click Here