Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

Top Showplan Operator

The Top operator scans the input, returning only the first specified number or percent of rows, possibly based on a sort order. The Argument column can 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.

Top is a logical and physical operator.

Top operator iconGraphical execution plan icon

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.