You are viewing documentation about an older version (1.12.1). View latest version

snowflake.snowpark.functions.dense_rank

snowflake.snowpark.functions.dense_rank() Column[source]

Returns the rank of a value within a group of values, without gaps in the ranks. The rank value starts at 1 and continues up sequentially. If two values are the same, they will have the same rank.

Example:

>>> from snowflake.snowpark.window import Window
>>> window = Window.order_by("key")
>>> df = session.create_dataframe([(1, "1"), (2, "2"), (1, "3"), (2, "4")], schema=["key", "value"])
>>> df.select(dense_rank().over(window).as_("dense_rank")).collect()
[Row(DENSE_RANK=1), Row(DENSE_RANK=1), Row(DENSE_RANK=2), Row(DENSE_RANK=2)]
Copy