SQL表中批量删数据

SQL某一个表中按条件查询到需要删除的数据，可能有几百条，正常查询到数据少的情况下点一下删一下，能不能批量删除这几百条数据。
where straid = '1'

delete from table where straid = '1'

delete from table where straid = '1'

delete from table where starid in (select * from table where XX);