Get 2nd highest salary from employee table and delete duplicate records with CTE expressions.

• Use a subquery to get the highest salary

• Use another subquery to get the 2nd highest salary

• Use CTE to delete...read more