Using the Relational Data Framework › Searched Operations › Statements Used in Searched Operations

Statements Used in Searched Operations

You can specify the WHERE clause and search criteria on four SQL statements-SELECT, UPDATE, DELETE FROM, and INSERT. When the data in a row meets the search criteria specified on a WHERE clause, SQL processes that data as follows:

• If a SELECT statement contains the WHERE clause, then SQL returns the data to the source that invoked the SELECT statement.
• If an UPDATE statement contains the WHERE clause, then SQL updates the rows containing data that matches the search criteria.
• If a DELETE FROM statement contains the WHERE clause, then SQL deletes the row containing data that matches the search criteria.
• If an INSERT statement contains the WHERE clause, then SQL retrieves the values to be inserted from rows matching the search criteria.