What is an SQL Window Function? A window is a set of rows or observations in a table or result set. In a table, you may have more than one window depending on how you specify the query.

In SQL Server, a function that returns a ... valued function” or “inline TVF”. A table-value function normally returns a set of rows, but it could be written to only return one.