Create biggest-single-number.sql

kamyu104 · web-flow · commit 5f2c566c4238 · 2017-10-20T10:38:42.000-05:00
diff --git a/MySQL/biggest-single-number.sql b/MySQL/biggest-single-number.sql
@@ -0,0 +1,19 @@
+# Time:  O(n)
+# Space: O(n)
+
+SELECT
+IFNULL(
+    (SELECT
+        MAX(num)
+    FROM
+        (SELECT
+            num
+        FROM
+            number
+        GROUP BY num
+        HAVING COUNT(num) = 1
+        ORDER BY NULL) AS t
+    )
+    , NULL
+) AS num
+;
