t sql how to do multiple delete with one where clause code example
Example 1: sql delete multiple conditions
DELETE FROM employees
WHERE last_name = 'Johnson'
AND employee_id >= 80;
Example 2: how to delete multiple rows in sql
// in order to do such use between keyword
delete from students
where id between 6 and 10