snowflake.snowpark.functions.desc_nulls_last¶

snowflake.snowpark.functions.desc_nulls_last(c: Union[Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/release-v1.6.1/src/snowflake/snowpark/functions.py#L5172-L5183)¶

Returns a Column expression with values sorted in descending order (null values sorted after non-null values).

Example::

CopyExpand

>>> df = session.create_dataframe([1, 2, 3, None, None], schema=["a"])
>>> df.sort(desc_nulls_last(df["a"])).collect()
[Row(A=3), Row(A=2), Row(A=1), Row(A=None), Row(A=None)]

Show lessSee more

Scroll to top