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

Can we have a Physical file without any member ? Please let me know

12 Answers

Suppose in CL we reach at end of file and again we have to reach from 1 record

3 Answers TCS,

What is the OPEN and CLOSE accesspath?

3 Answers CTS,

RPG/400 faqs?

1 Answers HSBC,

can anyone explain aboutovrOVRDBF,OPNQRYF, OVRSCOPE and OPNSCOPE?

2 Answers TCS,

Q1.How to read the Array? Q2.How to copy the content of one Array to another Array?

4 Answers IBM,

Can we journel logical file and access path? Can we use commitment control for non-join L.F?

4 Answers

Please help me, I have created window subfile,I have created Footer with same lengh and postion of window SFL. When I call the pgm, first is shows only Footer and then it shows subfile records.This time Footer is not showsing ..plz hel me how can i do it...? Sameple DDS and RPG: A R WIN1 SFL A*%%TS SD 20090130 165346 MUNSHIJ REL-V4R2M0 5769- PW1 A FLD001 1Y 0B 4 3EDTCDE (Z) A ATFILE R O 4 7REFFLD (QWHFDBAS/ATFILE LIB/LIBF- A ILE) A R WINCTL SFLCTL (WIN1) A*%%TS SD 20090202 123459 MUNSHIJ REL-V4R2M0 5769- PW1 A ALTNAME ('y') A SFLSIZ (0004) A SFLPAG (0004) A WINDOW (FOOTER) A ROLLUP (27) A ROLLDOWN (28) A CF12 (12 'Cancel') A 50 SFLDSP A N51 SFLDSPCTL A 51 SFLCLR A 1 2'Select Option,Press enter' A 2 3'1= Select' A R FOOTER A* A WINDOW(8 31 9 43) A 8 4'F12 = Cancel' A R DUMMY ASSUME A 24 10' ' in RPG: Dow *IN12 = *Off Write Footer Fxfmt WInCTL

2 Answers

what is the difference between SETON RT & RETURN?

5 Answers

how to check on which PF , the LF is dependant ?

4 Answers IBM,

i'm working on progA , in that program i want to see the userids of the users who work on this program?

10 Answers Four soft,

Set on command is used for closed all opened files , initialize var and release resource , return cmd is used for return to calling program but my req. Is dnt close opened files and resource must released while doing transactions , how can i do this...?

0 Answers

For more RPG400 Interview Questions Click Here