SHARE
TWEET

Untitled

a guest Mar 20th, 2019 70 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top