Interested to Buy Any Domain ? << Click Here >> for more details...
write the SQL statement to retrieve the 2nd Highest salary
ammount(File Name="EMPLOY",Field Name="SALARY")
- 6 Answers
- 20588 Views
- Bally Technologies, Cognizant, Vertex, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
records can be read/update/deleted with which file?
what is the command to know key fields of file?
define a output queue?
How do you check object lock
if dspatr(pc) and csrloc were specified for a format, which keyword would have priority?
What Is The Error If We Don't Get Login Screen?
What is diff between EVAL & MOVE?
How do I remove a flag or check no. or name when a user opens too many sessions?
how many printer files maximum can be used in single rpg program?
define subsystem?
what is the function of cpysplf command?
what are the limitations of cl (compare to rpg) ?
how can you specify no duplicate key?
what is message file?
can we use ASCII ,CDUP,SENDPASV commands in SFTP?
