Domanda di colloquio di Deloitte
Second highest salary with SQL?
Risposta di colloquio
Anonimo
7 giu 2017
SELECT name, MAX(salary) AS salary FROM employee WHERE salary < (SELECT MAX(salary) FROM employee);
Second highest salary with SQL?
Anonimo
SELECT name, MAX(salary) AS salary FROM employee WHERE salary < (SELECT MAX(salary) FROM employee);