Viridien Interview Question
1. select second largest salary from the table
Interview Answer
Anonymous
Apr 22, 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.