How to get the second highest from a Table

Query:

select max(emp) from pr where emp in (select top 2 * from pr order by emp desc)