Computer Science
Given the following tables :
Orders (OrdNo, Ord_date, ProdNo#, Qty)
Product (ProdNo, Descp, Price)
Payment (OrdNo, Pment)
Write a query to delete all those records from table Orders whose complete payment has been made.
DDL & DML
8 Likes
Answer
DELETE FROM Orders
WHERE OrdNo IN (
SELECT Payment.OrdNo
FROM Payment
WHERE Payment.Pment = 'COMPLETE');
Answered By
5 Likes
Related Questions
Give commission of Rs.500 to all employees who joined in year 1982 (table Empl).
Allocate the department situated in BOSTON to employee with employee number 7500 (tables EMPL, Dept)
Enlist the names of all tables created by you.
Write Query statements for following transaction : (Consider tables of question 12)
- Increase price of all products by 10%.
- List the details of all orders whose payment is pending as per increased price.
- Decrease prices by 10% for all those products for which orders were placed 10 months before.