GlobalLogic
Part of Hitachi
Engaged employer
GlobalLogic interview question
Find 2nd topmost record from a table based on the Salaries using SQL
Interview Answer
Anonymous
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