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?
harsh.lapashiya
Old Hand
Points: 398
More actions
November 15, 2011 at 7:45 am
#1407894
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))