Export (0) Print
Expand All

Top

SQL Server 2000

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

Show:
© 2014 Microsoft