Now You Try It
The Human Resources department is responsible for keeping track of all skill information for the company. Right now, they need to see which skill IDs and names are currently on file. Create a SELECT statement to retrieve and display skill IDs and names from the SKILL table.
Look in Appendix C, “Table Descriptions” to identify the column names.
The result looks like this:
SKILL_ID SKILL_NAME -------- ---------- 5420 Writing 4444 Assembly 5160 Calculus 1000 Management 4420 Telephone 7000 Sales 4410 Typing 6666 Billing 3065 Electronics 5430 Mktng Writing 6470 Window Installation 5130 Basic Math 5500 Gen Mktng 5180 Statistics 6670 Gas Engine Repair 6770 Purchasing 4370 Filing 1030 Acct Mgt 5309 Appraising 4490 Gen Ledger 6650 Diesel Engine Repair 4430 Interviewing 3333 Bodywork 3088 Brake work 5200 Gen Acctng 4250 Data Entry
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.
What message do you see?
You see a message stating the number of rows that have been retrieved.
|
Copyright © 2014 CA.
All rights reserved.
|
|