1. Categories >> Software >> MainFrame >> IBM AS400 >> RPG400
  2. Suggest New Category

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

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 can you display specific subfile page on the screen in unequal subfile?

0 Answers   IBM,

1. Which Built-In-Function will you use to achieve the following functionality? CLONO1NO2NO3 Factorl÷÷+OpcdeFactor2++÷ResultLenDHHiLoEq C QTY IFLT *ZERO C QTY MULT -1 QTY C ENDIF a) %ABS b) %TRIM c) %TRIMS d) %UNS

3 Answers   IBM,

what is EXCEPT command in rpg and use

1 Answers   Active Brains,

i would like to know under what circumstance the object will get locked on AS400.

5 Answers   IBM,

Thanks gagan for your answer,i'm new to as400,i don't know embedded sql in rpg.can you send me the coding for the below mentioned question in embedded sql rpg. how to retrieve particular field records from a physical file,say i have a physical file called 'employee' in it i have to retrieve the records of a field 'admin' present in pf 'employee' using rpg,but i should not use logical file or openquery file.

2 Answers   iGate,




How to search particular records from the database file in rpg?

2 Answers  

What is a record lock error?

0 Answers   Wipro,

what do you mean by an input subfile, what are the keywords required?

0 Answers   IBM,

Are all these RPG/400 Interviewed Questions being asked recently? are current?

1 Answers  

Is it possible to call a subfile using CL. IF yes.. kindly help me out with explanation...?

3 Answers  

What is the RPG cycle?

3 Answers   CSC,

how to display all the members records in a physical file without using ovrdbf?

9 Answers  

For more RPG400 Interview Questions Click Here
Categories