Now You Try It
Only sales employees at Commonwealth Auto receive bonuses as part of their earnings. Payroll wants a list of all employees who do not receive bonuses.
Enter a SELECT statement to retrieve all employees from the POSITION table for which the database does not have a bonus percentage. Display employee ID.
The result looks like this:
EMP_ID ------ 3411 3411 4773 3338 2246 2246 1034 2424 3767 3449 3082 3341 4660 2209 2894 1765 4456 1765 3991 3778 4358 4962 2180 2180 2106 3222 4002 2437 2096 2096 2004 2004 5103 5008 4321 2598 3764 2461 1234 1003 4027 2466 2174 2781 3704 4008 3433 3288 3841 4703 3294 3769 3118 53 rows processed
If your results do not match what you see above, check Review Answers for Chapter 4 for the correct SQL syntax. Remember that result tables may be shortened in this guide.
IS NOT NULL
Use IS NOT NULL to eliminate rows containing nulls in a specified column.
|
Copyright © 2014 CA.
All rights reserved.
|
|