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;
SELECT * FROM Customers FETCH 10;
Not sure why they two commands for the same purpose, But both of them just works.
Read great educational content like this and a lot more !
Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too