06 Oct 19 · npack · #Snowflake ·   Bookmark   ×

Rank() syntax in Snowflake

Rank() is a OLAP function is snowflake:

SELECT firstname, department, startdate,
RANK() OVER ( PARTITION BY department ORDER BY startdate ) AS rank
FROM Employees;


posted on 06 Oct 19

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

AzharuddinKOct 23 12:05

Can you please share examples related with unbounded preceding as well

npackOct 23 11:41

Sure. Wrote an article today. Checkout snowflake window functions

Community Software by Hittly