Nth Highest salary-Oracle

above will give nth max salary info

2. using rank function

since there is a duplicate at 4, it ommits next rank 5,goes to 6. if we need 5th ,then we can use densk_rank

Recent Posts

A fully detailed, interview- and workshop-ready case study you can use as a blueprint for migrating a legacy digital-lending stack...

Key Challenges & How We Handled Them 1. Business Logic Locked in Forms & PL/SQL Challenge: Oracle Forms often embed complex validations,...