CONCAT function
The concat function combines strings into a single string. This function is useful for merging text data or creating composite keys.
The concat function combines strings into a single string. This function is useful for merging text data or creating composite keys.
Counts the number of distinct values by given group.
The cumsum function calculates the cumulative sum of a numeric column. This function is useful for performing running totals, which are common in financial calculations, cumulative performance analysis, and tracking progressive data trends.
Finds the maximum value in a column.
Finds the minimum value in a column.
The row_number function assigns a sequential integer to each row in the data set. This function is typically used to generate a unique identifier for each row, which can be useful for ranking, pagination, and identifying specific rows in ordered datasets.
The rows function counts the total number of rows in a data set.
Calculates the total sum of numeric values in a column.