Question d’entretien chez Viridien
1. select second largest salary from the table
Réponse à la question d'entretien
Utilisateur anonyme
22 avr. 2019
SELECT name, MAX(salary) AS salary FROM employee WHERE salary < (SELECT MAX(salary) FROM employee);
1. select second largest salary from the table
Utilisateur anonyme
SELECT name, MAX(salary) AS salary FROM employee WHERE salary < (SELECT MAX(salary) FROM employee);