Find 2nd highest salary using not in or <> operator
Exercise
Correct!
select max(salary) from employee
where salary
not in
code_here
select max(salary) from employee where salary not in (select max(salary) from employee)
assert(line3 == l3);
function rpls(str){ return str.toLowerCase().replace(/'/g,'').replace(/ /g, ''); } var l3 = rpls("(select max(salary) from employee)");