Delete Statement

DELETE FROM tablename
[ WHERE search-condition ]

Delete one or many rows in a table. In general search-condition and qualification may not involve a sub select on tablename.



DELETE FROM PART WHERE qoh < 4.00;

Previous slide

Next slide

Back to first slide

View graphic version