Nth Highest salary-Oracle

Anand Nerurkar
Mar 22, 2024
1 min read

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

See All

Java 8 coding preparation

AI Risk Metrices

🏦 KEY BANKING RISK METRICS (EXPLAINED SIMPLY) 🔍 What is AUC (in Credit / Risk Models)? AUC = Area Under the ROC Curve In simple terms: AUC measures how well a model can distinguish between good and

Gen AI USe case Estimation

✅ How to Build Estimation for a GenAI Use Case Step 1: Identify the Use Case Scope What business problem are you solving? (Customer support, document processing, fraud detection, etc.) Who are the end

Comments