New
The Learning module is now live
See what's new
×
Question Bank
Learning
NEW
Pricing
Blog
Forum
HOT
JobRadar
Description
Solution
Discussion
Submissions
Ask AI
Question Bank
SQL Question
AI Insights
Quick Summary
Identify unique product combinations that appear together within the same transaction.
Count transaction occurrences for each combination and isolate the highest frequency.
Return all tied top-frequency pairs while enforcing a consistent product ordering.
What This Tests
Self-joins for combinatorial pairing
Deduplication to handle multi-item transactions
Conditional filtering before aggregation
Maximum value extraction with tie handling
Consistent ordering of symmetric pairs
Common Patterns
Self Join
Deduplication
Aggregation
Subquery
Collapse
Hint 1
Hint 2
What Interviewers May Ask Next
Accepted
8
/22
Acceptance Rate
36.4%
Ask AI Assistant
Ask AI Assistant
Ask me anything about this coding question!
Qwen
Qwen3.6-Flash
0/2000
Run
Submit
Test Cases
SQL Schema
Pandas Schema
Input
-
Output
-
Expected
-
