Delete From <Table name> where < codition >

Delete from EMP where job=’clerk’

Delete operation can be rollback