Add support for standard nested window functions in T-SQL

The ISO/IEC SQL:2016 standard defines a concept called nested window functions that allows you to nest two kinds of window functions as an argument of a window aggregate function. The idea is to allow you to interact with row markers representing strategic points in windowing elements like the beginning or end of the partition, beginning or end of the frame, the current outer row, and the current inner frame row.The two standard nested window functions are the nested row number function and the nested value_of expression at row function.The former allows you to refer in an argument of a window aggregate function to a row number at a specified row marker. Here�s the syntax of the nested row number function:

Under Review

ProgrammabilitySuggestions

0 Comments

You must to comment