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
- 20568 Views
- Bally Technologies, Cognizant, Vertex, I also Faced
- E-Mail Answers
Answer Posted / suresh miryala
select top 1 from (select top 2 from emp order by sal desc)A
order by sal
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
how will you search an array?
what are the three line types in rlu ?
what is the purpose of indicators in rpg?
how to develop some simple graphs (bar charts) using just html?
Difference Between Interactive & Batch Job?
define what a data area is along with a brief example of what it may be used for?
Difference between NOPASS & OMIT?
difference between view and index ?
how can I predict the performance of my cgis?
The content of Physical file is as below: hfcftp wruquief SENDPASV 0 CDUP ASCII GET 01100901.CSV ramndk/ECP505.EC0110090 (REPLACE QUIT Thw above commands will get executed when we call STRTCPFTP from CL program.... Now if I want to use SFTP what can be the solution? plz reply in detail....Thank you for ny help... I m using RPG/ILERPG to download...
Why we are not able to perform insert delete and update operation in Join logical file?
define the purpose of the *cat function?
when do you use f-spec. Continuation line ?
how can I start a page in a new window?
what are indicators?
