How can you find the 2nd Highest salary in a file department wise in abinitio?
- 9 Answers
- 45213 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
Why might the optimizer use a table scan when an index is available?
What is rollup component?
What is local and formal parameter?
Do you think effective communication is necessary for data processing?
What is common among data validity and data integrity?
what is the use of catlog or catlogfile?
What do you mean by the term data warehousing? Is it different from data mining?
Have you worked with packages?
Explain how you can run a graph infinitely in ab initio?
To which project that prefix will set is to private project or public project or both?how and where to set?
What is the purpose of having stored procedures in a data-based?
What are the different types of partition components in abinitio?
How co> operating system natively processes the data?
Where $mpjret is used in ab-initio?
What is MAX CORE of a component?
