create table Employee(Empno integer(3) primary key,Ename varchar(20) not null, Designation varchar(20),Deptno integer(3));

insert into Employee values(111, "Rajesh","Salesman",203);
insert into Employee values(241, 'Poonam',"Analyst",104 );
insert into Employee values(222, 'Rishi','President', 111);
delete from Employee where Deptno=111;
select * from Employee;