If you want to find duplicate rows in SQL, you can go two routes. The first is to use the GROUP BY

Read More
How To Find Duplicates in SQL using Window Functions

The purpose of this article is to introduce you to SQL window functions and some of the high-level concepts.  In SQL, a

Read More
Window Functions in SQL – What are they?

In this puzzle, we’re going to learn how to find a gap in a sequence using SQL Server.  I was recently reviewing

Read More
How to Find a Gap in a Sequence using SQL SERVER

In this puzzle, we’re going with with SQL Percentile Rank to work through a problem to identify the top and bottom student

Read More
SQL Percentile Rank Puzzle