100%(3)3 out of 3 people found this document helpful
This preview shows page 93 - 98 out of 352 pages.
Limiting Rows Using a Selection“retrieve allemployees in department 90”EMPLOYEES…Limiting Rows Using a SelectionIn the example in the slide, assume that you want to display all the employees in department 90. The rows with a value of 90 in the DEPARTMENT_IDcolumn are the only ones that are returned. This method of restriction is the basis of the WHEREclause in SQL.