Analytics: 14 NTH_VALUE in windows
blog: https://connor-mcdonald.com
Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax. In this session, we look at how the nth_value function can be used to explore different boundary values within a window
The sample problem we'll solve is: Compare current data with the 2nd lowest and 2nd highest values within our window.
Scripts: https://livesql.oracle.com/apex/lives...
