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.

With the latest release of SQL Server, Microsoft produced 14 new T-SQL functions. These functions can be separated into four different categories, as seen in Table 1. These functions will be ...

With such a huge percentage of all our IT systems relying on data to function, SQL will not be going away any time soon. So, let’s celebrate SQL turning 50, and consider how we can continue to ...