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
- 20605 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
some special characters I key in my html source members show different on my web pages. Why? How can I solve this?
what is the difference between normal upddta to pf and updating using dfu program?
what is the purpose of the indara keyword?
difference between view and index ?
what is the function of cpysplf command?
i am using non join multiple format my 3 database file is like that pf97 R REC ENAME ETENNO ESTATUS K ENAME pf98 R REC1 ENAME ESAL K ENAME PF99 R REC3 ENAME CRDCARD EID K EID & MY NON JOIN LOGICAL FILE IS ALSO SAME EXCEPT RECORD NAMES BEFORE I TRIED WITH 2 FILES SO ITS SAYS ERROR I.E.(Key field attributes must be same as for previous formats. ) SO I CHANGED KEYFIELD ACCORDING TO PF SO ITS WORKING BUT AFTER ADDING 3 FILES ITS SAYING SAME ERROR . I DONT KNOW I NEW IN AS400 PLLZ HELP ME I HAVE ONE MORE QUE. CANT BE USE DIFFERENT KEYFIELD (NOT ACCORDING TO PF) IN NON JOIN LOGICAL FILE.
what is the difference between seton lr and retrn?
what are the different commands used in rlu ?
What is %CHECK?
what are all the contents of subfile?
Why we sometimes use same file name in file and tofile in ovrdbf and sometimes different?
what if my system I runs with system value qccsid 65535?
where can you specify an indicator in lokup operation?
is their a difference in cobol400 for the release 5.2 and 6.1 at the as400.
What is access path in as400?
