GlobalLogic
Parte de Hitachi
Empleador activo
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 sep 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