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
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