Home Forums Article Discussions Article Discussions by Author Discuss content posted by VM How well do you know MAX? RE: How well do you know MAX?

  • August 5, 2011 at 9:00 pm

    #1364732

    Dave62 (8/5/2011)

    For those who were expecting the third highest salary, here is a select for that [...]

    Or, slightly more compactly:

    select max(Salary) from @table where Salary <

    ((select max(Salary) from @table where Salary < (select max(Salary) from @table)))

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi