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...
Watch video Analytics: 14 NTH_VALUE in windows online without registration, duration hours minute second in high quality. This video was added by user SQL and Database explained! 22 February 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,456 once and liked it 30 people.