Homework answers / question archive / How do I delete? From Problem 8

How do I delete? From Problem 8

Computer Science

Share With

---

How do I delete? From Problem 8.1--8.4

Problem 2

Having created the table structure in Problem 1, write the SQL code to enter the first two rows for the table shown in Figure P8.2. Each row should be inserted individually, without using a subquery. Insert the rows in the order that they are listed in the figure.

OPTION 2:

Delete the entry with EMP_NUM of 100. It is important to delete this so that you would meet the expected output

 

This one:

 

100 News John G 2000-11-08 502