Using Conditional Retrieval › Using Keywords in Predicates › Exercise 4-9

Exercise 4-9

Now You Try It

How would you display all departments associated with NEW CARS?

The result looks like this:

DEPT_ID  DEPT_NAME
-------  ---------
   4200  LEASING - NEW CARS
   2210  SALES - NEW CARS
   3520  APPRAISAL NEW CARS
   1110  PURCHASING - NEW CARS

4 rows processed

If your results do not match what you see above, check Review Answers for Chapter 4 for the correct SQL syntax. Remember, result tables may be shortened in this guide.

Use NOT in front of LIKE to search for rows containing all values except those that match the mask.