1.

Write a query to find the 2nd highest salary of an employee from the employee table?

Answer»

You can USE this SELECT MAX(SALARY) FROM employee WHERE Salary NOT IN ( SELECT Max(Salary) FROM employee); Query to find the 2nd highest salary of the employee.



Discussion

No Comment Found