Partition idea (high level DDL)
SQL
Hard
3 views
Problem Description
Orders table is huge. Create a monthly partitioned table outline for order_date.
Output Format
DDL statement(s)
Sample Test Case
Input:
Orders(order_date, ...)
Output:
Partitioned design
Constraints
Partition syntax varies; show a clear template
Official Solution
CREATE TABLE Orders (order_id INT PRIMARY KEY, order_date DATE NOT NULL, customer_id INT NOT NULL, total_amount DECIMAL(10,2) NOT NULL);
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!