Reading Time: 5 minutes Window functions are a great thing to know when querying data in a Microsoft SQL Server database. If you need an introduction to SQL Server window functions, you should definitely check out my full tutorial on the topic: SQL Server Window Functions: An introduction for beginners Also, all the information Continue Reading
SQL LAG and LEAD Window Functions: Explained
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
What’s the difference between RANK and DENSE_RANK? Answered!
Reading Time: 5 minutes The RANK and DENSE_RANK window functions in SQL Server are very handy when you need to gather ranking information from your data. But do you know the difference between the two? The difference is subtle, but important. This tutorial assumes you know a thing or two about window functions in Continue Reading
NTILE window function: How it works
Reading Time: 6 minutes The NTILE window function in Microsoft SQL Server can be used to rank data in a dataset. This function is definitely worth knowing if you want to learn all there is to know about querying data in SQL Server. In this brief tutorial, we’ll discuss what the NTILE function is Continue Reading
DENSE_RANK: Explained with examples
Reading Time: 8 minutes The SQL Server DENSE_RANK function is a simple window function you should know to help gather meaningful information from your data. The DENSE_RANK function is one of four ranking window functions we have available to us in Microsoft SQL Server. You should understand all the ranking window functions if you Continue Reading
SQL Server RANK: A window function you should know
Reading Time: 9 minutes The SQL Server RANK function is a simple window function you should know to help 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 RANK function is Continue Reading
SQL Server ROW_NUMBER: A window function you should know
Reading Time: 8 minutes The SQL Server ROW_NUMBER function is a simple window function 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 ROW_NUMBER function Continue Reading
SQL Server Ranking Window Functions: ROW_NUMBER, RANK, DENSE_RANK, NTILE
Reading Time: 10 minutes When querying data in a SQL Server database, there may be times when you want to rank rows in your dataset. Maybe you want to rank Customers by how much they have spent in your store, or maybe you want to rank Products from most expensive to least expensive. SQL Continue Reading