The Top logical and physical operator will scan the input, returning only the first specified number or percent of rows. The Argument column can optionally contain a list of the columns that are being checked for ties. In update plans, the Top operator is used to enforce row count limits.
| Limiting Result Sets Using TOP and PERCENT | SET ROWCOUNT |