Reading Time: 9 minutes The SQL Server LAG and LEAD functions are simple window functions you should know to help you gather meaningful information from your data. Window functions are considered an advanced tool when querying data in SQL Server. If you’re trying to learn about window functions, congratulations, you’re moving up! The LAG and Continue Reading
FIRST_VALUE and LAST_VALUE: SQL window functions you should know
Reading Time: 9 minutes The SQL Server FIRST_VALUE and LAST_VALUE functions are simple window functions you should know to help you gather meaningful information from your data. Window functions are considered an advanced tool when querying data in SQL Server. If you’re trying to learn about window functions, congratulations, you’re moving up! The FIRST_VALUE Continue Reading
SQL Server Offset Window Functions: FIRST_VALUE, LAST_VALUE, LAG, LEAD
Reading Time: 12 minutes Offset window functions are very useful tools you should know when querying databases in Microsoft SQL Server. There are several different window functions available to us. You should know all of them if you want to be the world’s best database developer. In this tutorial, we’re going to discuss the four Offset Continue Reading