Viridien interview question
1. select second largest salary from the table
Interview Answer
Anonymous
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
Anonymous
SELECT name, MAX(salary) AS salary FROM employee WHERE salary < (SELECT MAX(salary) FROM employee);
Check out your Company Bowl for anonymous work chats.