Second Highest Salary

Problem We have an employee table that holds a list of employees, their names, and their salaries. Table: employee Column Name Type employee_id integer name string salary integer The employee_id column is the primary key. Your job is to write a query that returns the second highest distinct salary value from this table. If the table contains fewer than two distinct salaries, your query must output null. When several employees earn exactly the second highest salary, the value…