• Skip to primary navigation
  • Skip to content
  • Skip to footer
Thomas Ngo's Developer Journal Thomas Ngo's Developer Journal
  • Home
  • Journal
  • Tags
  • About
    Thomas Ngo

    Thomas Ngo

    Software Engineer

    • Stanton, California
    • Email
    • GitHub
    • Resume

    SQL problem - Biggest Single Number

    February 21, 2024 less than 1 minute read

    Page Navigation

    • Problem
    • Query
    • Editorial Solution

    Problem

    problem-619

    Query

    SELECT IFNULL(
        (SELECT num
        FROM MyNumbers
        GROUP BY num
        HAVING COUNT(num) = 1
        ORDER BY num DESC
        LIMIT 1)
        , NULL) as num
    

    Editorial Solution

    SELECT
        MAX(num) AS num
    FROM
        (SELECT
            num
        FROM
            my_numbers
        GROUP BY num
        HAVING COUNT(num) = 1) AS t;
    

    Tags: SQL

    Updated: February 21, 2024

    Share on

    Twitter Facebook LinkedIn
    Previous Next

    You may also enjoy

    Problem of The Day: Find Minimum Time to Reach Last Room II

    May 7, 2025 1 minute read

    Problem Statement

    Problem of The Day: Number of Equivalent Domino Pairs

    May 4, 2025 1 minute read

    Problem Statement

    Problem of The Day: Minimum Domino Rotations For Equal Row

    May 3, 2025 2 minute read

    Problem Statement

    Problem of The Day: Push Dominoes

    May 2, 2025 2 minute read

    Problem Statement

    • Follow:
    • GitHub
    • LinkedIn
    © 2025 Thomas Ngo.