Try Another
Enter a SELECT statement to display all departments that are not associated with associated with NEW CARS.
The result looks like this:
DEPT_ID DEPT_NAME ------- --------- 1120 PURCHASING - SERVICE 4900 MIS 5000 CORPORATE ACCOUNTING 4500 HUMAN RESOURCES 4600 MAINTENANCE 2200 SALES - USED CARS 5100 BILLING 6200 CORPORATE ADMINISTRATION 3530 APPRAISAL - SERVICE 6000 LEGAL 3510 APPRAISAL - USED CARS 1100 PURCHASING - USED CARS 5200 CORPORATE MARKETING 13 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.
|
Copyright © 2014 CA.
All rights reserved.
|
|