Delete Rows Using a Subquery
Delete all customers who have never placed an order.
Table schema
Customers(id INT PRIMARY KEY, name VARCHAR(50))
Orders(id INT PRIMARY KEY, customer_id INT)Sample data
Customers: (1, Aman), (2, Riya), (3, Karan)
Orders: (1, customer 1), (2, customer 3)
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.