solved Biggest Single Number problem

Shubham-Bhoite · Shubham-Bhoite · commit ff09abb37edb · 2025-01-24T15:35:41.000+05:30
diff --git a/Solutions/Problem-24.sql b/Solutions/Problem-24.sql
@@ -0,0 +1,22 @@
+/* 24.Biggest Single Number :
+
+Table: MyNumbers
++-------------+------+
+| Column Name | Type |
++-------------+------+
+| num         | int  |
++-------------+------+
+This table may contain duplicates (In other words, there is no primary key for this table in SQL).
+Each row of this table contains an integer.
+ 
+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.
+*/
+
+SELECT MAX(num) AS num
+FROM (
+    SELECT num
+    FROM MyNumbers
+    GROUP BY num
+    HAVING COUNT(num) = 1) 
+    AS single_numbers;
