How to find the second largest salary from an employee table using sql command?
Answers
Answered by
1
SQL query for find second highest salary of employee? SQL query for find second highest salary of employee?
Top answer · 4 votes
SELECT sal FROM emp ORDER BY sal DESC LIMIT 1, 1; More
3 votes
SELECT name, MAX(salary) AS salary FROM employee WHERE salary < (SELECT MAX(salary) FROM
Similar questions