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-kotlin Show documentation

Kotlin-based LeetCode algorithm problem solutions, regularly updated

There is a newer version: 1.30

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