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
SQL Server Window Functions: An introduction for beginners
Reading Time: 16 minutes Window functions in SQL Server are very powerful tools we can use to gather meaningful information from our database. 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! Do you need to understand how Continue Reading
SQL Server Custom Data type: A How-To Guide
Reading Time: 5 minutes One of the more interesting things you can do within Microsoft SQL Server is create your own custom data type. The process is actually very simple. In this very brief tutorial, we’re going to learn how to create a custom data type in SQL Server. We’ll discuss these topics: The Continue Reading