Hearing the Oracle

Home » Posts tagged 'percent_rank'

Tag Archives: percent_rank

Categories

Exploring Analytic Functions : an Iterative Approach

April 23, 2015 11:24 AM / Leave a comment

Lake Malawi

Lake Malawi

Suppose some quixotic HR evangelist fresh off a stint of social aid work in Malawi is pushing the bombastically non-Libertarian idea of normalizing compensation patterns within departments as follows: employees who have high tenure seniority contrasted with low salary ‘seniority’ will receive pay adjustments. This is the sort of question that can be explored with Oracle’s analytic SQL functions.     Continue…