Can I perform top 10 syntax in snowflake database?

6.29K viewsSQL
0

Can I perform top 10 syntax in snowflake database?

Gisele Casillas Answered question January 22, 2022
0

Yes, you can perform top syntax in the snowflake database.

It can be done by using TOP and this will constrain the maximum number of rows returned by statement or subquery.
Important to Note: When you use TOP make sure that is a non-negative integer constant and also note that LIMIT is equivalent to TOP .

Furthermore, when using TOP the ORDER BY clause does not have to be used. But if you DO NOT use the clause then the results will be non-deterministic as the results within the result set are not in a specific order. So if you want to ensure that the results returned are controlled, be sure to use the ORDER BY clause.

Gisele Casillas Answered question January 22, 2022
You are viewing 1 out of 1 answers, click here to view all answers.