Implicit Filtering

Oftentimes our filtering logic involves applying the same logical expression to multiple columns. Implicit filtering allows us to succinctly apply one or more logical expressions to one or more columns and then combine the results without repeating code.

Implicit filtering involves three aspects:

  1. Selection of column(s) on each of which we will apply filtering logic which we cover in Column Selection.
  2. The choice of logical operation (either AND or OR) to use to combine the output of applying the specified expression( s) to the selected column(s) which we cover in Relationship Specification.
SQL
I/O