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 - 3 of 3 Answers

Ranga

  • 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