Pergunta de entrevista da empresa Fractal

SQL query to find the second highest salary in an employee database.

Resposta da entrevista

Sigiloso

25 de set. de 2024

Use ORDER BY DESC and LIMIT 2 OFFSET 1 Alternatively, use subqueries to find the MAX salary greater than the overall maximum salary