second-highest-salary

java

python3

python

javascript

typescript

csharp

golang

kotlin

swift

rust

ruby

dart

scala

elixir

erlang

racket

bash

mysql

mssql

postgresql

oraclesql

pythondata

Database

Table: <code>Employee</code>

<pre>
+-------------+------+
| Column Name | Type |
+-------------+------+
| id | int |
| salary | int |
+-------------+------+
id is the primary key (column with unique values) for this table.
Each row of this table contains information about the salary of an employee.
</pre>

&nbsp;

Write a solution to find&nbsp;the second highest distinct salary from the <code>Employee</code> table. If there is no second highest salary,&nbsp;return&nbsp;<code>null (return&nbsp;None in Pandas)</code>.

The result format is in the following example.

&nbsp;
Example 1:

<pre>
Input: 
Employee table:
+----+--------+
| id | salary |
+----+--------+
| 1 | 100 |
| 2 | 200 |
| 3 | 300 |
+----+--------+
Output: 
+---------------------+
| SecondHighestSalary |
+---------------------+
| 200 |
+---------------------+
</pre>

Example 2:

<pre>
Input: 
Employee table:
+----+--------+
| id | salary |
+----+--------+
| 1 | 100 |
+----+--------+
Output: 
+---------------------+
| SecondHighestSalary |
+---------------------+
| null |
+---------------------+
</pre>