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

Answer Posted / bhabani

This is working fine if we have only one person who is getting second highest salary..what if more than 1 person's are getting the same amount of salary ?

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why might the optimizer use a table scan when an index is available?

1811


how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio

1314


Do you think effective communication is necessary for data processing?

731


What is a look-up?

666


Explain the difference between the truncate and delete commands?

613






Suppose you find the term validation mentioned with a set of data, what does that simply represent?

586


What is ab initio enterprise meta>environment (eme)?

891


Have you used rollup component? Describe how.

664


i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?

1615


What are the steps to create a repository in ab initio?

756


What are the features of ab initio?

627


What is the max core of a component?

624


Define ramp limit in ab initio?

776


What is de-partition in abinitio?

890


What is the difference between formal and export parameter? Export at what secenario we are going to use?

2152