Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

1.Where we declare Variables in RPG/400,RPGIV,RPGILE.? 2.When do we use D-spec and I-spec in real time ?.what is difference between them?

1 Answers   HP,

Setps to create .csv file on IFS folder in AS/400( V4R3)....?

3 Answers   TCS,

write an RPG program to calculate the marks of 5 students (A,B, C, D, E)in 3 different subjects (eng, math, sci) an display on the screen

0 Answers  

3 members in databasefile .how to read records from all the members??

6 Answers   CTS,

How would display prime numbers using CL program?

0 Answers   Hexaware,

How to update physical file in rpgle without using display file?

4 Answers   GalaxE, IBM, TCS,

Anybody know the difference of primary file and full procedural file

4 Answers  

this is rpg3 code W0RTN IFEQ @CN,002 what is the means @CN,002

1 Answers  

When will DUMP & DEBUG be ignored?

3 Answers   IBM,

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  

If there are 1000 member(PGM type) in a SRC file. How can we compile in a CL program? ( It need to be done in a loop)?

1 Answers  

How do I read records from Subfile? what is the purpose of READC explain with example?

4 Answers   IBM,

For more RPG400 Interview Questions Click Here
Categories