Replace a view
SQL
Easy
0 views
Problem Description
Update v_active_products to include category as well.
Output Format
View replaced
Sample Test Case
Input:
Products(category)
Constraints
Use CREATE OR REPLACE if supported
Official Solution
CREATE OR REPLACE VIEW v_active_products AS SELECT product_id, name, category, price FROM Products WHERE is_active = 1;
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!