Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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")

Answer Posted / kamal

hi,
select max(salary) from empfile where salary <(select max
(salary from empfile))

or

select salary from empfile a 2=(select count(salary) from
from empfile b where b.salary>=a.salary)

Is This Answer Correct ?    24 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

which are the member types which seu supports?

1326


when do you use f-spec. Continuation line ?

1705


can we define multi-dimensional arrays in rpg ?

1629


is there any way to dynamically merge other html scripts into a given html?

1071


Space & Skip Are Which Level Keywords?

1191


In 'o' Specs What Is The Opcode For Write?

1194


define data structure?

1754


name few ibm supplied libraries?

2107


if dspatr(pc) and csrloc were specified for a format, which keyword would have priority?

1670


what is the use of sflend keyword?

1849


how do you read data area in an rpg program?

1809


what is the function of crtdupobj command?

2067


any one have give AS400 study material? pls pass it to gopalsai789@gmail.com

1707


what are the three types of keywords associated with printer file ?

1690


How to reverse a string using RPG?

1486