SQLQuokka
Start practicing
QuestionsLearnSandboxFeaturesRoadmapFAQ

Largest Unique Number

Unsolved

numbers can contain duplicates. A number is unique when it appears exactly once in the table. Return the largest unique number; if no number is unique, the query must still return one row containing NULL. Write an SQL query that returns a single column, num.

SQL Query Editor (Ctrl+Enter to run)
0 characters · Valid
Canonical Solution Official

Official Solution is Hidden

Try solving the question with the schema explorer and hints first. When ready, reveal the verified canonical query and step-by-step logic breakdown.

Community Q&A & Discussion

Ask questions, share alternate queries, and explore solutions

0 comments
Asked By:
Classic pattern · not tied to a specific company

Submission History

Your recent query executions and answer checks

Execution Pipeline:
FROM numbers
Full source dataset
10 rows total
Ready. Type a query to see live execution.
Clause: Auto-Sync · AlaSQL Engine