CitiusTech Interview Question

SQL command to print the second highest salary in the emp table

Interview Answer

Anonymous

Apr 4, 2022

SELECT MAX (salary) from emp where sal<(SELECT MAX(salary) from emp)