empolyee

an anonymous user · April 08, 2021 · SQL
CREATE TABLE EMPLOYEE (
     empid int(20),
    empname varchar(100),
    managerid int(20),
    deptid int(20),
    salary int(100),
    DOB int(50)
);
insert into EMPLOYEE values('1','emp1','0','1','6000','1982-08-06');
  insert into EMPLOYEE values('2','emp2','0','5','6000','1982-07-11');
   insert into EMPLOYEE values('3','emp3','1','1','2000','1983-11-21');
insert into EMPLOYEE values('13','emp13','2','5','2000','1984-03-09');


 

Comments

Please sign up or log in to contribute to the discussion.