nikesh, Sql Server

nikesh

CREATE TABLE employee(
    emp_ID int NOT NULL  PRIMARY KEY ,
    EMPNAME varchar(250),
    EMPLASTNAME varchar(200) UNIQUE,
    COMPANY varchar(250),
    AGE int CHECK(AGE>=18),
    SALARY int,
    );
    INSERT INTO employee(emp_ID,EMPNAME,EMPLASTNAME,COMPANY,AGE,SALARY)
    VALUES ('1','nikesh','padisetti','TCS','21','30000');
    INSERT INTO employee(emp_ID,EMPNAME,EMPLASTNAME,COMPANY,AGE,SALARY)
    VALUES('2','vinnu','m','WIRPO','20','35000');
    INSERT INTO employee(emp_ID,EMPNAME,EMPLASTNAME,COMPANY,AGE,SALARY)
    VALUES('3','blessy','victoria','TCS','21','30000');
    INSERT INTO employee
    VALUES('4','bhanu','katta','INFOSYS','21','30000');
    INSERT INTO employee
    VALUES('5','asha','t','HCL','21','25000');
    INSERT INTO employee
    VALUES('6','swathi','dasari','CTS','21','34000');
    INSERT INTO employee
    VALUES('7','Jeevan','ch','AMAZON','22','50000');
    INSERT INTO employee
    VALUES('8','bhargav','reddy','MPASIS','25','40000');
    INSERT INTO employee
    VALUES('9','JOHN','kennedy','INFOSYS','22','32000');
    INSERT INTO employee
    VALUES('10','prudvi','s','GOVJOB','35','40000');
    SELECT * FROM employee


run \| edit \| history \| help	0