SQL query to retrieve the second highest salary from each department

• Use the RANK() function to assign a rank to each salary within each department

• Filter the results to only include rows with a rank of...read more

select Distinct salary from Customer_id

order by salary desc

Limit 1,1 ;