Finding the Nth maximal value: An extension of the MAX T-SQL function

(Eli Leiba) The following procedure gets a tablename, column and integer (N) as parameters and finds the Nth largest value of a column in a specific table. For example, running it with “products,” “UnitPrice,” and “13,” retrieves the 13th largest value of the UnitPrice column from the products table

Read More - Register for Free Membership