This Leetcode problem Biggest Single Number LeetCode Solution is done in SQL.
List of all LeetCode Solution
![Biggest Single Number LeetCode Solution](https://i0.wp.com/totheinnovation.com/wp-content/uploads/2024/02/LeetCode-Problem-Solution.png?resize=200%2C200&ssl=1)
Biggest Single Number LeetCode Solution
Table of Contents
Problem Statement
Column Name | Type |
num | int |
MyNumbers
This table may contain duplicates (In other words, there is no primary key for this table in SQL). Each row of this table contains an integer.
A single number is a number that appeared only once in the MyNumbers
table.
Find the largest single number. If there is no single number, report null
.
The result format is in the following example.
Example 1:
Input:
num |
8 |
8 |
3 |
3 |
1 |
4 |
5 |
6 |
Output:
num |
6 |
Explanation: The single numbers are 1, 4, 5, and 6. Since 6 is the largest single number, we return it.
Example 2:
Input:
num |
8 |
8 |
7 |
7 |
3 |
3 |
3 |
num |
null |
Explanation: There are no single numbers in the input table so we return null.
Biggest Single Number LeetCode Solution MySQL
select
max(num) as num
from
(
select
num
from
my_numbers
group by
num
having
count(num) = 1
) as n;
Code language: SQL (Structured Query Language) (sql)