Q1: Q2: select max(SAL) from EMP_TAB where SAL

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 / raj

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How to call one program from another program in RPG? please help me with the code

1733

What is difference between bind by copy and bind by reference?

2480

How can we override a file during runtime in rpg?

1204

thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400

2317

what is an online rpg?

1266

What is the difference between copybooks and subprocedures in as400?

1361

can I touch the array during treatments?

1177

how do you use commitment control in rpg?

1285

how can I tell when to replace the array?

1219

Explain mdt?

1138

Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg

1147

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

1261

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

1310

What is the purpose of record level identifier?

1128

What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?

3002