Reading Time: 8 minutesThe SQL Server EXISTS predicate is a very handy tool we can use when querying SQL Server databases. Do you need to know how EXISTS works? You’ve come to the right place! In this very brief tutorial, we’ll discuss how the EXISTS predicate works and provide examples of how to Continue Reading
Querying data
Correlated Subqueries: A Beginner’s Guide with Examples
Reading Time: 8 minutesThere are many very helpful querying tools available to us in Microsoft SQL Server. One of the more complicated querying tools to understand is correlated subqueries. If you are new to SQL Server, I would understand if you simply don’t “get” correlated subqueries. They are a bit strange to wrap Continue Reading
SQL Server REPLACE: Explained
Reading Time: 4 minutesThe SQL Server REPLACE function is a very simple system function that is built into Microsoft SQL Server. It is one of the best tools you can use for string manipulation in SQL Server. In this very brief tutorial, we’ll discuss the SQL Server REPLACE function and how to use Continue Reading
What’s the difference between ROWS and RANGE? Explained!
Reading Time: 5 minutesWindow 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 minutesThe 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 minutesThe 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 minutesOffset 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 minutesThe 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 minutesThe 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 minutesThe 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