roshni k v


{ City } pune
< Country > india
* Profession * project engineer
User No # 85357
Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 19
Users Marked my Answers as Wrong # 11
Questions / { roshni k v }
Questions Answers Category Views Company eMail




Answers / { roshni k v }

Question { IBM, 44004 }

How can you find the 2nd Highest salary in a file department wise in abinitio?


Answer

you can use roll up to calculate dept wise salary first and
then sort it with key as sal. create indexes using
next_in_sequence() and then filter out the 2nd record.

hope this helped!!

Is This Answer Correct ?    19 Yes 11 No