Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

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 icon Graphical execution plan icon

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft