write the SQL statement to retrieve the 2nd Highest salary
ammount(File Name="EMPLOY",Field Name="SALARY")
- 6 Answers
- 18256 Views
- Bally Technologies, Cognizant, Vertex, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / yogesh
This is correct answer -Try it
SELECT SALARY FROM EMPLOYEE WHERE SALARY < (SELECT MAX
(SALARY) FROM EMPLOYEE) ORDER BY SALARY DESC FETCH FIRST 1
ROW ONLY
| Is This Answer Correct ? | 12 Yes | 2 No |
Answer / aravind.r
select min(SALARY) from EMPLOY where SALARY in
(select top 2 SALARY from EMPLOY order by SALARY desc)
| Is This Answer Correct ? | 7 Yes | 5 No |
Answer / sandeep
select top 1 salary from employee where salary<(select top 1 salary from employee order by salary desc) order by salary desc
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / vivek dwivedi
Select max(salary) from file where salary not in (select max(Salary) from file)
| Is This Answer Correct ? | 0 Yes | 0 No |
select top 1 from (select top 2 from emp order by sal desc)A
order by sal
| Is This Answer Correct ? | 1 Yes | 2 No |
what is the syntax for plist?
What are the different types of keywords in display files?
Why we are not able to perform insert delete and update operation in Join logical file?
How to reverse a string using RPG?
what is cab?
which of the following operations does not zero the field flda defined as 4,0?
pf named karthik 3members jan feb mar cmd must executed create mbr ar ap
how can a cgi check whether an ifs object is available?
In 'o' Specs What Is The Opcode For Write?
which are the figurative constants used in rpg?
What is a Library in AS/400?
What is a message file?
RPG400 
