recent

Titulo

Employee Table

Employee Table Structure:

CREATE TABLE employee (
 empno INT PRIMARY KEY,
 ename VARCHAR(10),
 job VARCHAR(9),
 mgr INT NULL,
 hiredate DATETIME,
 sal NUMERIC(7,2),
 comm NUMERIC(7,2) NULL,
 dept INT)

Employee Table Data:

begin
insert into employee values 
 (1,'JOHNSON','ADMIN',6,'12-17-1990',18000,NULL,4)
insert into employee values 
 (2,'HARDING','MANAGER',9,'02-02-1998',52000,300,3)
insert into employee values 
 (3,'TAFT','SALES I',2,'01-02-1996',25000,500,3)
insert into employee values 
 (4,'HOOVER','SALES I',2,'04-02-1990',27000,NULL,3)
insert into employee values 
 (5,'LINCOLN','TECH',6,'06-23-1994',22500,1400,4)
insert into employee values 
 (6,'GARFIELD','MANAGER',9,'05-01-1993',54000,NULL,4)
insert into employee values 
 (7,'POLK','TECH',6,'09-22-1997',25000,NULL,4)
insert into employee values 
 (8,'GRANT','ENGINEER',10,'03-30-1997',32000,NULL,2)
insert into employee values 
 (9,'JACKSON','CEO',NULL,'01-01-1990',75000,NULL,4)
insert into employee values 
 (10,'FILLMORE','MANAGER',9,'08-09-1994',56000,NULL,2)
insert into employee values 
 (11,'ADAMS','ENGINEER',10,'03-15-1996',34000,NULL,2)
insert into employee values 
 (12,'WASHINGTON','ADMIN',6,'04-16-1998',18000,NULL,4)
insert into employee values 
 (13,'MONROE','ENGINEER',10,'12-03-2000',30000,NULL,2)
insert into employee values 
 (14,'ROOSEVELT','CPA',9,'10-12-1995',35000,NULL,1)
end

How your Table looks like?

Select * from employee;


















No comments

Powered by Blogger.