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?

  • July 22, 2012 at 3:57 pm

    #1516021

    harsh.lapashiya (11/15/2011)

    good twister

    To get third highest salary

    select MAX(salary) from Employees where salary <(select MAX(salary) from Employees

    where salary <(select MAX(salary) from Employees))

    I know this is a year old post but I just wonder how the performance would be when you have a large Employees table. Is this the recommended method to do it?

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA