g0601_0700.s0619_biggest_single_number.script.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of leetcode-in-java Show documentation

Java-based LeetCode algorithm problem solutions, regularly updated

There is a newer version: 1.37

# Write your MySQL query statement below
# #Easy #Database #2023_06_05_Time_779_ms_(66.08%)_Space_0B_(100.00%)
SELECT MAX(num) AS num
FROM (SELECT num, COUNT(num)
      FROM MyNumbers
      GROUP BY num
      HAVING COUNT(num) = 1) t