Pergunta de entrevista da empresa Viridien
1. select second largest salary from the table
Resposta da entrevista
Sigiloso
22 de abr. de 2019
SELECT name, MAX(salary) AS salary FROM employee WHERE salary < (SELECT MAX(salary) FROM employee);
1. select second largest salary from the table
Sigiloso
SELECT name, MAX(salary) AS salary FROM employee WHERE salary < (SELECT MAX(salary) FROM employee);