Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- insert into EMPLOYEES (first_name, lastname, email, address, position) values ('JONATHAN', 'JAVINAR', 'javinar@amanila.edu.ph', 'ANONAS QC', 'DEAN');
- insert into EMPLOYEES (first_name, last_name, email, address, position) values ('HELEN GAYLE ', 'VALDEZ', 'valdez@amanila.edu.ph', 'PURESA MANILA', 'ADMISSION');
- insert into EMPLOYEES (first_name, last_name, email, address, position) values ('JOCELYN', 'NAYON', 'jocelyn@amanila.edu.ph', 'SAMPALOC MANILA', 'CASHIER');
- insert into EMPLOYEES (first_name, last_name, email, address, position) values ('LORACE', 'REY SANTOS', 'santos@amanila.edu.ph', 'PARANAQUE', 'GUIDANCE/OSA');
- insert into EMPLOYEES (first_name, last_name, email, address, position) values ('KENNY ROBERTSON', 'TAN', 'krntan@amanila.edu.ph', 'TONDO MANILA', 'IT INSTRUCTOR');
- insert into EMPLOYEES (first_name, last_name, email, address, position) values ('ABEGAIL', 'FELICES', 'felices@amanila.edu.ph', 'TONDO MANILA', 'REGISTRAR');
- insert into EMPLOYEES (first_name, last_name, email, address, position) values ('NICOLE', 'LAURENTE', 'laurente@amanila.edu.ph', 'STA.MESA MANILA', 'HR');
- insert into EMPLOYEES (first_name, last_name, email, address, position) values ('GEORGE', 'LAO', 'lao@amanila.edu.ph', 'TONDO MANILA', 'IT');
- insert into EMPLOYEES (first_name, last_name, email, address, position) values ('ABEGAIL', 'FELICES', 'felices@amanila.edu.ph', 'TONDO MANILA', 'LIBRARIAN');
- insert into EMPLOYEES (first_name, last_name, email, address, position) values ('GUIA', 'ANGELIQUE', 'angelique@amanila.edu.ph', 'STA.MESA MANILA', 'DEAN');
- UPDATE EMPLOYEES SET POSITION = 'REGISTRAR' WHERE POSITION = 'OIC REGISTRAR';
- insert into EMPLOYEES (first_name, last_name, email, address, position) values ('EVITA ', 'ALEJANDRO', 'alejandro@amanila.edu.ph', 'SAMPALOC MANILA', 'SCHOOL DIRECTOR');
- DELETE FROM EMPLOYEES WHERE POSITION = 'IT';
- UPDATE EMPLOYEES SET ADDRESS = 'CAVITE' WHERE POSITION = 'OIC REGISTRAR';
- SELECT DISTINCT ADDRESS FROM EMPLOYEES;\
- SELECT FIRST_NAME FROM EMPLOYEES ORDER BY FIRST_NAME ASC;
- SELECT * FROM EMPLOYEES WHERE POSITION = 'REGISTRAR';
- insert into employees columnname
- alter table EMPLOYEES
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement