Question d’entretien chez GlobalLogic

Find 2nd topmost record from a table based on the Salaries using SQL

Réponse à la question d'entretien

Utilisateur anonyme

28 sept. 2022

Using the WHERE clause, we can check for the condition where the Salaries are less than the MAX(Salary), then querying the first record after sorting by DESC