Pre Row Salary, Next Row Salary, Rank and Dense Rank

How to find out second highest salary as group wise by using datastage? Can you explain scenarios like pre row salary, next row salary, rank and dense rank

Showing Answers 1 - 1 of 1 Answers


  • Sep 6th, 2019

Pre and next row salary can be get using analytical functions lag() and lead() functions in SQL

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions