T-SQL Query to Find the Second Highest Column Value in a Table

One of my favorite technical interview question on SQL Server is "What query would you write to find the second highest column value in a table?" The question seems easy, however most developers fail to answer to this. Read this post for the answer.