T-SQL 101: #26 Limiting output rows in SQL Server T-SQL queries by using the TOP operator

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


The TOP operator is used to restrict the number of rows being returned. If you're familiar with other database engines, you might have used a LIMIT operator. TOP is a bit like that. You can see that in the first query shown below: If you look at the bottom query, you can see that it ...