Saturday, February 6, 2010

nth maximum value from table

select Max(empage) from Emp
where empage not in (select top 1 empage from Emp  order by EmpAge desc )

No comments: