20 Oct 18 · Ryan-Dallas ·       Add to Favorites  

How to SELECT TOP n rows from Snowflake

I spent a good amount of career working on Teradata, I was wondering if we have any equivalent to TOP function in Snowflake

To select top 10 rows from a table:

SELECT * FROM Customers LIMIT 10;

or 

SELECT * FROM Customers FETCH 10;

Not sure why they two commands for the same purpose, But both of them just works.

Ryan-Dallas

posted on 20 Oct 18

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds

Copied