Press "Enter" to skip to content

TOP in Snowflake

Kevin Wilkie covers the TOP operator and the SAMPLE function in Snowflake:

Nothing flashy or fancy about this. But notice in SQL Server, especially in the newer versions, it wants me to use paranthesis around the 100. I try that in Snowflake and I get this ugly message:

Bringing this back to SQL Server, yeah, use the parentheses around TOP, like TOP(25) instead of TOP 25. It’s better that way.