Create Ranking Column

[mgalvan]

I need to write a sql statement that will look at values in a column, sort them accordingly, and then create a new column
that ranks the values...essent ially just creates a column of increasing integers in the order of the sorted column.