write the SQL statement to retrieve the 2nd Highest salary
ammount(File Name="EMPLOY",Field Name="SALARY")
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
what is the difference between normal upddta to pf and updating using dfu program?
what does check opcode is used?
in conjunction with which statements can orxx and andxx conditions be used ?
Which command is used to replace CDUP command in FTP IF i WANT TO USE SFTP?
what are different types of substems?
is it possible to create a physical file without dds?
WHAT IS FERERENTIAL INTRIGRITY ?
What are the record format field mapping options in cpyf?
define what a data queue is along with a brief example of what it may be used for?
at what level s,o are defined and what they will do?
If I want to execute Sftp commands(LS & GET) stored in Physical file from CL program automatically...Can u Plz tell me how can I do this?...How the script will look?? THANX FOR NY HELP...
different type of cursor?
what is term cua , saa?
if we tried to move year part of *iso date into a field of length 3, what will happen ?
what is a primary file?