I recently was asked by a colleague about finding the Nth highest value in a table. For example if there is an employee table then finding the 10th highest salary or something similar. I thought about it