This preview shows page 1. Sign up to view the full content.
Unformatted text preview: INSERT INTO EMP_1 VALUES ('101', 'News', 'John', 'G', '08-Nov-00', '502') INSERT INTO EMP_1 VALUES ('102', 'Senior', 'David', 'H', '12-Jul-89', '501') 3. Assuming that the data shown in the EMP_1 table have been entered, write the SQL code that will list all attributes for a job code of 502. SELECT JOB_CODE FROM EMP_1 ; 6. Write the SQL code to delete the row for the person named William Smithfield, who was hired on June 22, 2004, and whose job code classification is 500. DELETE FROM EMP_1 WHERE EMP_LNAME = Smithfield...
View Full Document
This note was uploaded on 07/13/2011 for the course IST 210 taught by Professor Mcconn,charlotteryoo,jungwoo during the Summer '08 term at Pennsylvania State University, University Park.
- Summer '08