SQL query to fetch second highest salary from employee table

• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT to fetch only the second row

• Consider handling cases where there may be tie...read more