Question d’entretien chez Amdocs

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