This Leetcode problem Second Highest Salary LeetCode Solution is done in SQL.
List of all LeetCode Solution
![Second Highest Salary LeetCode Solution](https://i0.wp.com/totheinnovation.com/wp-content/uploads/2024/02/LeetCode-Problem-Solution.png?resize=200%2C200&ssl=1)
Second Highest Salary LeetCode Solution
Table of Contents
Problem Statement
Column Name | Type |
id | int |
salary | int |
Employee
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.
Write a solution to find the second highest salary from the Employee
table. If there is no second highest salary, return null (return None in Pandas)
.
The result format is in the following example.
Example 1:
Input:
id | salary |
1 | 100 |
2 | 200 |
3 | 300 |
Output:
SecondHighestSalary |
200 |
Example 2:
Input:
id | salary |
1 | 100 |
Output:
SecondHighestSalary |
null |
Second Highest Salary LeetCode Solution MySQL
select
FirstName,
LastName,
City,
State
from
Person as p
left join Address as a on p.PersonId = a.PersonId;
Code language: SQL (Structured Query Language) (sql)