TOP
Description
Some parts in the output code are omitted for clarity reasons.
Limits the rows returned in a query result set to a specified number of rows or percentage of rows. When you use TOP
with the ORDER BY
clause, the result set is limited to the first N number of ordered rows. Otherwise, TOP
returns the first N number of rows in an undefined order. Use this clause to specify the number of rows returned from a SELECT
statement. Or, use TOP
to specify the rows affected by an INSERT
, UPDATE
, MERGE
, or DELETE
statement. (SQLServer TOP documentation)
Syntax in SQL Server
To get more information about the TOP
arguments please check the SQL Server TOP documentation.
Syntax in Snowflake
To get more information about TOP
arguments please check the Snowflake TOP documentation.
Sample Source Patterns
To execute correctly the following samples it is required run the next CREATE TABLE
statement:
Common Case
SQL Server
Snowflake
TOP using PERCENT
SQL Server
Snowflake
Since PERCENT
argument is not supported by Snowflake it is being removed from the TOP
clause, that's why the result of executing the query in Snowflake is not equivalent to SQL Server.