Cross join for combinations
SQL
Easy
2 views
Problem Description
Create all combinations of Sizes(s) and Colors(c) to generate SKU options.
Sample Test Case
Input:
Sizes(size), Colors(color)
Official Solution
SELECT s.size, c.color FROM Sizes s CROSS JOIN Colors c;
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!