T-SQL 101: #27 Using TOP WITH TIES to include matching rows in SQL Server T-SQL Queries

added by DotNetKicks
8/21/2019 12:40:15 PM

1 Kicks, 162 Views

In the previous T-SQL 101 post, I showed the TOP operator. One of the challenges that comes up though, is if I say SELECT TOP (10) FROM dbo.Products ORDER BY Size, what if there are 5 items with the first Size, and 7 products with the second Size?