Specifies that either an explicit number of rows or an explicit percentage of rows is to be returned from the query result set.
ANSI Compliance
TOP n is a Teradata extension to the ANSI SQL:2011 standard.
Other SQL dialects use similar operators with names such as:
- FIRST n
- LIMIT n
- SET ROWCOUNT n
- STOP AFTER n