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
- 20571 Views
- Bally Technologies, Cognizant, Vertex, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Pose, there are 100 records in the file.i need to retrieve all the records matching/equal to the particular name field. How can we do the above using search criteria other than using the if cond?
how do you know that records are locked?
what key word is used when screen is re-display?
what would be the effect on the field where reverse image, underline and highlight display attributes were active?
what are the three types of keywords associated with printer file ?
can anybody give the interview questions list of RLU. plz mail me: dinesh_sati07@yahoo.com
What is program status data structure(psds) in as400?
what is the use of dspatr(mdt) keyword?
how many specifications are there in rpg/400? What are they?
what are the two record formats a subfile contain ?
Write a CL program which will run a batch job at 1 am every night
Why we sometimes use same file name in file and tofile in ovrdbf and sometimes different?
In RPG How to read a records from a file without using read opcodes?
What is access path in as400?
What Does 'sr' In Columns 7-8 Of C Specs Mean?
