Data Virtuality Pipes and Pipes Pro Data Developer Guide SQL Clauses Current: WHERE Clause WHERE Clause The WHERE clause defines the criteria to limit the records affected by the SELECT, UPDATE, and DELETE statements.The general form of the WHERE clause is as follows:WHERE Criteria ×