See Subqueries for complete information about subqueries.See Where Clause for details.The following example changes every record that meets the conditions in the Where clause. In this case, the salary and exempt status are changed for all employees having the employee ID E10001. Because employee IDs are unique in the emp table, only one record is updated.
![]() |
© 2013 Progress Software Corporation and/or its subsidiaries or affiliates. |