We help IT Professionals succeed at work.

delete multiple records

How do I delete multiple records in my table.  

For example I want to delete IDs 68, 69, and 70

Please correct this

delete from tblmonthlyreport1 where ID = 68,69,70
Comment
Watch Question

Senior Developer
BRONZE EXPERT
Commented:
You should use:

DELETE FROM tblmonthlyreport1 where ID IN (68,69,70)

Explore More ContentExplore courses, solutions, and other research materials related to this topic.