SQL DELETE ROW

The SQL DELETE ROW operation removes specific rows from a table based on a condition. This is particularly useful when you want to delete erroneous or obsolete data while keeping the rest of the table intact.

The WHERE clause in the DELETE statement ensures only the targeted rows are removed.

Example

This example removes the row where the product is "Tablet".

-- Delete the row where the product is 'Tablet'
DELETE FROM Orders
WHERE Product = 'Tablet';

-- View the updated table
SELECT * FROM Orders;
            

Explanation

- The DELETE statement targets the row with the condition Product = 'Tablet'.
- Only the row matching the condition is removed.
- The updated table no longer includes the "Tablet" row, while other rows remain unaffected.