# 176. Second Highest Salary

### Description

&#x20;Write a SQL query to get the second highest salary from the `Employee` table.

| Id | Salary |
| -- | ------ |
| 1  | 100    |
| 2  | 200    |
| 3  | 300    |

&#x20;For example, given the above Employee table, the query should return `200` as the second highest salary. If there is no second highest salary, then the query should return `null`.

| SecondHighestSalary |
| ------------------- |
| 200                 |

### Constraints

### Approach

### Links

* GeeksforGeeks
* [Leetcode](https://leetcode.com/problems/second-highest-salary/)
* ProgramCreek
* YouTube

### **Examples**

{% tabs %}
{% tab title="Example 1" %}
**Input:**

{"headers": {"Employee": \["Id", "Salary"]}, "rows": {"Employee": \[\[1, 100], \[2, 200], \[3, 300]]\}}

**Output:**

{"headers": \["SecondHighestSalary"], "values": \[\[200]]}
{% endtab %}
{% endtabs %}

### **Solutions**

{% tabs %}
{% tab title="Solution 1" %}
```sql
# MySQL query statement

SELECT MAX(salary) AS SecondHighestSalary 
FROM Employee 
WHERE salary != (SELECT MAX(salary) FROM Employee);
```
{% endtab %}

{% tab title="Solution 2" %}
```sql
# MySQL query statement

SELECT DISTINCT
    Salary AS SecondHighestSalary
FROM
    Employee
ORDER BY Salary DESC
LIMIT 1 OFFSET 1
```
{% endtab %}
{% endtabs %}

### **Follow up**

*
