122_biggest_single_number.md

SQL Everyday #122

Biggest Single Number

Site: LeetCode
Difficulty per Site: Easy

Problem

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. [Full Description]

Submitted Solution

-- Submitted Solution
SELECT
    MAX(num) AS num
FROM (
    SELECT
        num
    FROM MyNumbers
    GROUP BY num
    HAVING COUNT(*) = 1
    ORDER BY num DESC
    ) AS n
;

Site Solution

-- LeetCode Solution 
-- Site solution essentially the same.

Notes

TODO

NB

TBD

Go to Index
Go to Overview