Advanced SQL Developer — Hard
Key points
- NTH_VALUE retrieves the value from a specific row in the window frame
- It does not find the nth largest value across the partition
- It is not used for calculating cumulative row counts
Ready to go further?
Related questions