Previous Topic: Exercise 7-2Next Topic: Using EXISTS

Nesting SELECT Statements › Using an Aggregate Function in a Nested SELECT Statement › Exercise 7-2 › Exercise 7-2B

Exercise 7-2B

Human Resources has requested you remove duplicate employees from the report.

 EMP_ID  NUM_DEPENDENTS


 ------  --------------
   1003               3
   1234               5
   1765               2
   2096               3
   2246               2
   2437               2
   2448               3
   2781               2
   2894               3
   3199               2
   3222               2
   3338               2
   3411               3
   3704               3
   3767               2
   3991               5
   4962               4
   5008               2
   5090               3

 19 rows processed

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