How can you find the 2nd Highest salary in a file department wise in abinitio?
- 9 Answers
- 44003 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / nikhil sali
We can use Scan.
1) First sort your data with 2 keys dept,salary description
2) In scan create one parameter say seq nbr and initialize it with 0.
3) in scan method increment it with 1
4) this will create rank in each group of dept
5) in output select method - select record where seq_nbr = 2
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the purpose of having stored procedures in a data-based?
Define ramp limit in ab initio?
What is the difference between look-up file and look-up, with a relevant example?
What is data encoding?
What does it mean by the term 'sort component'?
Why might the optimizer use a table scan when an index is available?
Pdl with an example?
What is the difference between sandbox and EME?
What is rollup component?
Suppose you find the term validation mentioned with a set of data, what does that simply represent?
List out some of the air commands used in abintio?
How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?
Difference between output_index and output_indexes in reformat
What is the syntax for m_dump in abinitio?
Describe the grant/revoke ddl facility and how it is implemented?
