Domanda di colloquio di Viridien
1. select second largest salary from the table
Risposta di colloquio
Anonimo
22 apr 2019
SELECT name, MAX(salary) AS salary FROM employee WHERE salary < (SELECT MAX(salary) FROM employee);
1. select second largest salary from the table
Anonimo
SELECT name, MAX(salary) AS salary FROM employee WHERE salary < (SELECT MAX(salary) FROM employee);