write the SQL statement to retrieve the 2nd Highest salary
ammount(File Name="EMPLOY",Field Name="SALARY")
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
What is the use of jdftval in as400?
if we tried to move year part of *iso date into a field of length 3, what will happen ?
is their a difference in cobol400 for the release 5.2 and 6.1 at the as400.
In 'o' Specs What Is The Opcode For Write?
how many files, printer files you can describe in a rpg?
what is the difference between *like and *namvar ?
How do you check object lock
what is the favicon.ico request that my site receives now and then?
can you have multiple key lists for a single file ?
how to declare a constant variable in the freeformat?
what are the three types of keywords associated with printer file ?
what is a query can be run in which mode?
what is rpg ?
which of the following operations does not zero the field flda defined as 4,0?
how can database records be read without lock ?