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

Question

Anonimo · Accepted Answer

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

GlobalLogic

Domanda di colloquio di GlobalLogic

Risposta di colloquio

Aziende seguite

Ricerche di lavoro