GlobalLogic
Parte de Hitachi
Empresa activa
Pregunta de entrevista de GlobalLogic
Find 2nd topmost record from a table based on the Salaries using SQL
Respuesta de la entrevista
Anónimo
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