How to get the second highest from a Table

How to get the second highest from your table like second highest salary or second highest number.

Query:

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