Explain 'Predicate' in SQL.

Explain 'Predicate' in SQL.

Approach: Define the logical condition in a query.

An expression that evaluates to TRUE, FALSE, or UNKNOWN. In SQL, predicates are typically found in the WHERE or HAVING clauses to filter rows.

Follow-up: What is a 'Sargable' predicate?

Key concepts: where clause, boolean.