06 Oct 19 ·  nVector in Snowflake ·        Bookmark ·  Report ·  More actions.. Lock comments ·  Pin thread

ROW_NUMBER() syntax in Snowflake

ROW_NUMBER() is  a OLAP function in Snowflake:

SELECT firstname, department, startdate,
ROW_NUMBER() OVER ( PARTITION BY department ORDER BY startdate ) AS row_num
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