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
- 20299 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
how can you detect and handle a record lock situation?
is there any way to dynamically merge other html scripts into a given html?
at what level s,o are defined and what they will do?
What is the Difference between command attention key and command function key ?
how to get the cursor position?
in conjunction with what other keyword must ovrdta and ovrata be used?
What are the mandatory keywords of sub file?
when would you use or not use this approach?
what is the sequence when using cursor?
how to toggle between single line and multi - line display of a particular record in a subfile?
what are the various types of device files?
what is the use of data structures?
what is the command to know key fields of file?
What is RETURN CURSER LOCATION in subfile?
Service Program : S1 Modules in S1 : M1 M1 having two procedures : ADD, SUB Current Binder Language STRPGMEXP PGMLVL(*CURRENT) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") ENDPGMEXP Doubt: I need to add one new Module to the Service Program M2 having one procedure ‘MULT’ How to add this new module to the service program S1 ? If I need to recreate the service program again, Do I need to mention the Module M1 again while recreating along with new Module M2? There is no Binding Directory. Binder language structure will be like this STRPGMEXP PGMLVL(*CURRENT) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") EXPORT SYMBOL("MULT") ENDPGMEXP STRPGMEXP PGMLVL(*PREVIOUS) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") ENDPGMEXP
