How to find 3rd max value of a column using MAX function in sql server?

Posted by Pandiya Chendur on Stack Overflow See other posts from Stack Overflow or by Pandiya Chendur
Published on 2010-03-19T04:32:46Z Indexed on 2010/03/19 4:41 UTC
Read the original article Hit count: 434

Yesterday i had a question in an interview which i thought i could find answers here in SO...

How to find 3rd max value of a column using MAX function in sql server?

Consider the column to be

Wages
20000
15000
10000
45000
50000

© Stack Overflow or respective owner

Related posts about sql-server-2005

Related posts about select