NTH_VALUE Gets Specific Position?!

NTH_VALUE extracts the Nth value from window! It's like array indexing for window functions. This positional access will surprise you!

#sql #sqltricks #nthvalue #windowfunctions #positionalaccess #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #advancedsql

https://www.youtube.com/watch?v=6wNXQoiEg8Y