Amdocs interview question

Was asked to write a SQL query to get the second highest number from a dataset.