Top K Values

Return the nth number of top values for a column

Function:

Top_Values(table = string, col = string, num_values = integer, new_table_name = string)




Parameters:

Table: Table name on which to perform function

col: Column for which to return the top

num_values: The number of rows to return for with top values. For example if you want the top 5 values then input the number 5

new_table_name: The name of the new table with the nth number of top values




Examples:

Top_Values(table = Budget, col = Amount, num_values = 10, new_table_name = Top_values_Budget)