Last updated on October 9th, 2024 at 10:02 pm

This Leetcode problem Biggest Single Number LeetCode Solution is done in SQL.

List of all LeetCode Solution

Biggest Single Number LeetCode Solution

Problem Statement

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:

Output:

Explanation: The single numbers are 1, 4, 5, and 6. Since 6 is the largest single number, we return it.

Example 2:
Input:

Explanation: There are no single numbers in the input table so we return null.

1. 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;