Question

write a query to sql display age where age is second highest​

Answer 1

Answer:

SELECT Salary FROM (SELECT Salary FROM Employee ORDER BY salary DESC LIMIT 2) AS Emp ORDER BY salary LIMIT 1; In this solution, we have first sorted all salaries form Employee table in decreasing order, so that 2 highest salaries come at top of the result set.

pls mark me as brainliest