Use delete statement with where clause.

For Ex, if there is a table emp, from which we have to delete multiple records simultaneously then use the condition with where clause, as we have done in the following query.

DELETE FROM emp where deptname='software';

The above query will then delete all the records of the employees whose deptname is software.