SQL to Return the nth Maximum Value

by | Aug 16, 2021 | CTE, sql

Sometimes what seems like a simple request might take a little bit of thinking to devise and implement a solution. Recently, I was asked how to write SQL that returns the nth maximum value from a column. If you think about it, it isn't too difficult.Assume that you...