View with security filter by city
SQL
Hard
0 views
Problem Description
Create v_my_city_customers that only returns customers for city='Delhi'.
Output Format
View created
Constraints
Simple row-level filter
Official Solution
CREATE VIEW v_my_city_customers AS SELECT customer_id, name, city FROM Customers WHERE city = 'Delhi';
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!