Advertisement
Guest User

Untitled

a guest
Mar 20th, 2019
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.13 KB | None | 0 0
  1. insert into EMPLOYEES (first_name, lastname, email, address, position) values ('JONATHAN', 'JAVINAR', 'javinar@amanila.edu.ph', 'ANONAS QC', 'DEAN');
  2. insert into EMPLOYEES (first_name, last_name, email, address, position) values ('HELEN GAYLE ', 'VALDEZ', 'valdez@amanila.edu.ph', 'PURESA MANILA', 'ADMISSION');
  3. insert into EMPLOYEES (first_name, last_name, email, address, position) values ('JOCELYN', 'NAYON', 'jocelyn@amanila.edu.ph', 'SAMPALOC MANILA', 'CASHIER');
  4. insert into EMPLOYEES (first_name, last_name, email, address, position) values ('LORACE', 'REY SANTOS', 'santos@amanila.edu.ph', 'PARANAQUE', 'GUIDANCE/OSA');
  5. insert into EMPLOYEES (first_name, last_name, email, address, position) values ('KENNY ROBERTSON', 'TAN', 'krntan@amanila.edu.ph', 'TONDO MANILA', 'IT INSTRUCTOR');
  6. insert into EMPLOYEES (first_name, last_name, email, address, position) values ('ABEGAIL', 'FELICES', 'felices@amanila.edu.ph', 'TONDO MANILA', 'REGISTRAR');
  7. insert into EMPLOYEES (first_name, last_name, email, address, position) values ('NICOLE', 'LAURENTE', 'laurente@amanila.edu.ph', 'STA.MESA MANILA', 'HR');
  8. insert into EMPLOYEES (first_name, last_name, email, address, position) values ('GEORGE', 'LAO', 'lao@amanila.edu.ph', 'TONDO MANILA', 'IT');
  9. insert into EMPLOYEES (first_name, last_name, email, address, position) values ('ABEGAIL', 'FELICES', 'felices@amanila.edu.ph', 'TONDO MANILA', 'LIBRARIAN');
  10. insert into EMPLOYEES (first_name, last_name, email, address, position) values ('GUIA', 'ANGELIQUE', 'angelique@amanila.edu.ph', 'STA.MESA MANILA', 'DEAN');
  11.  
  12. UPDATE EMPLOYEES SET POSITION = 'REGISTRAR' WHERE POSITION = 'OIC REGISTRAR';
  13.  
  14. insert into EMPLOYEES (first_name, last_name, email, address, position) values ('EVITA ', 'ALEJANDRO', 'alejandro@amanila.edu.ph', 'SAMPALOC MANILA', 'SCHOOL DIRECTOR');
  15.  
  16. DELETE FROM EMPLOYEES WHERE POSITION = 'IT';
  17.  
  18. UPDATE EMPLOYEES SET ADDRESS = 'CAVITE' WHERE POSITION = 'OIC REGISTRAR';
  19.  
  20. SELECT DISTINCT ADDRESS FROM EMPLOYEES;\
  21.  
  22. SELECT FIRST_NAME FROM EMPLOYEES ORDER BY FIRST_NAME ASC;
  23.  
  24. SELECT * FROM EMPLOYEES WHERE POSITION = 'REGISTRAR';
  25. insert into employees columnname
  26.  
  27. alter table EMPLOYEES
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement