write the SQL statement to retrieve the 2nd Highest salary
ammount(File Name="EMPLOY",Field Name="SALARY")
- 6 Answers
- 18251 Views
- Bally Technologies, Cognizant, Vertex, I also Faced
- E-Mail Answers
Answer Posted / vivek dwivedi
Select max(salary) from file where salary not in (select max(Salary) from file)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how can I control from my cgis the cache of a remote browser?
name few ibm supplied libraries?
What are the mandatory keywords of sub file?
what are the various types of device files?
how many maximum spaces could be given in o specs?
how would you design the process for a nightly, high volume check producing process that needs to select only records that are flagged to be processed?
when would you use or not use this approach?
how do you know that records are locked?
how can I automatically refresh a web page?
Hi,Please give me the the answer for these quesitons? 1.what is IFS and ICF and RAPE amd DISKET fils? explain with example please? 2.What is the difference between POST AND SPACE OPCODES? 3.Can anybody tell me default printerfile command and object type?
how to define to define a hidden filed in dspf ?
what is the purpose of putovr (put with explicit override) keyword?
what is message file?
when is a tag statement used in rpg?
how can I control the way a remote browser uses its cache?
