Now You Try It
Earlier, you produced a report that displayed department ID and name from the DEPARTMENT table. Produce the same report and rename the headings "Department ID" and "Name."
The result looks like this:
DEPARTMENT ID NAME ------------- ---- 1120 PURCHASING - SERVICE 4200 LEASING - NEW CARS 4900 MIS 2210 SALES - NEW CARS 3520 APPRAISAL NEW CARS 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 1110 PURCHASING - NEW CARS 17 rows processed
If your results do not match what you see above, check Review Answers for Chapter 3 for the correct SQL syntax. Remember that result tables may be shortened in this guide.
|
Copyright © 2014 CA.
All rights reserved.
|
|