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
- 20313 Views
- Bally Technologies, Cognizant, Vertex, I also Faced
- E-Mail Answers
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 are different types of substems?
how to pick up the changed records every time in a subfile after the first change made ?
which are the member types which seu supports?
Difference Between Skip Before & Space Before?
Can level check error occur if we do chgpf?
how to run other job when one job is active?
what is sflpag and sflsiz ?
how many types of display are available on as/400 for user interaction?
how many printer files maximum can be used in single rpg program?
what is the maximum number of parameters allowed in rpg?
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.
which type of object is used in db2/400?
define a shared access path?
what does check opcode is used?
what is elastic and non elastic subrile?
