Top

Optimizing SQL Database Performance

Optimizing Database Performance

Top

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.

See Also

Limiting Result Sets Using TOP and PERCENT

SET ROWCOUNT