BS IT AFTERNOON 47

Monday, 27 March 2017

CREATE TABLE Employee

(

EMPID INT Primary key generated always as identity (start with 1,increment by 1),

ENAME VARCHAR(30),

JOB VARCHAR(30),

SALARY INT

);

INSERT INTO EMPLOYEE (ENAME,JOB, SALARY) VALUES('SMITH', 'CLERK', 800 );

INSERT INTO EMPLOYEE (ENAME,JOB, SALARY) VALUES('ALLEN', 'SALESMAN', 1600);

INSERT INTO EMPLOYEE (ENAME,JOB, SALARY) VALUES('WARD', 'SALESMAN', 1250);

INSERT INTO EMPLOYEE (ENAME,JOB, SALARY) VALUES('JONES', 'MANAGER', 1600);

INSERT INTO EMPLOYEE (ENAME,JOB, SALARY) VALUES('BLAKE', 'SALESMAN
', 2850);

INSERT INTO EMPLOYEE (ENAME,JOB, SALARY) VALUES('ALLEN', 'SALESMAN
', 5000);

S.I.A BOOK

HTML BOOK