Pregunta de entrevista de Viridien
1. select second largest salary from the table
Respuesta de la entrevista
Anónimo
22 abr 2019
SELECT name, MAX(salary) AS salary FROM employee WHERE salary < (SELECT MAX(salary) FROM employee);
1. select second largest salary from the table
Anónimo
SELECT name, MAX(salary) AS salary FROM employee WHERE salary < (SELECT MAX(salary) FROM employee);