Biggest Single Number
Apple
Problem Statement
Product analysts at Apple are reviewing dataset integrity. A "single number" is a number that appeared only once in the table. You need to find the largest one.
Write an SQL query to report the largest single number.
Rules:
- If there is no single number, report null.
- The result should be a single column named num.
- Results must be sorted in descending order (though only one value is expected).
Tests your understanding of
Basic SQL, Aggregation, Subquery and HAVING Clause
Input Tables
mynumbers
| num(INTEGER) |
|---|
| 8 |
| 8 |
| 3 |
| 3 |
| 1 |
| 4 |
| 5 |
| 6 |
Expected Output
| num(INTEGER) |
|---|
| 6 |
Tags
EasyBasic SQLAggregationSubqueryHAVING Clause
5-10 min
48%