Program1, Sql Server

Program1

CREATE TABLE employee
(
    emp_id INTEGER,
    first_name VARCHAR(20),
    last_name VARCHAR(20),
    salary INTEGER,
    department VARCHAR(20),
    city VARCHAR(20)
);

INSERT INTO employee(emp_id, first_name, last_name, salary, department, city) VALUES(1, 'John', 'Abraham', 1000000, 'Banking', 'Delhi');
  INSERT INTO employee(emp_id, first_name, last_name, salary, department, city) VALUES(2, 'Michael', 'Clarke', 1000000, 'Insurance', 'Banglore');
  INSERT INTO employee(emp_id, first_name, last_name, salary, department, city) VALUES(3, 'Roy', 'Thomas', 1000000, 'Banking', 'Gujarat');
  INSERT INTO employee(emp_id, first_name, last_name, salary, department, city) VALUES(4, 'Tom', 'Jose', 1000000, 'Insurance', 'Delhi');
  INSERT INTO employee(emp_id, first_name, last_name, salary, department, city) VALUES(5, 'Jerry', 'Pinto', 1000000, 'Insurance', 'Banglore');
  INSERT INTO employee(emp_id, first_name, last_name, salary, department, city) VALUES(6, 'Philip', 'Mathew', 1000000, 'Services', 'Chandigarh');
  INSERT INTO employee(emp_id, first_name, last_name, salary, department, city) VALUES(7, 'Amir', 'Khan', 1000000, 'Services', 'Delhi');
  
  SELECT *
  FROM EMPLOYEE;


run \| edit \| history \| help	0