Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API
Returns true if all input values are true; otherwise returns false. Equivalent to BOOL_AND.
Syntax
every(<expression>)
Arguments
Required
<expression>: An expression of typeboolean.
Returns
Returns a boolean value. Returns NULL if no rows are selected.
Considerations
- Equivalent to
BOOL_AND. - NULL values are ignored in the calculation.
Examples
Check All Conditions
Check if every product is in stock.
SELECT every(in_stock) AS all_in_stock
FROM products
WHERE category = 'Electronics';
Validate by Group
Ensure all items in each group meet a condition.
SELECT vendor_id, every(is_verified) AS all_verified
FROM products
GROUP BY vendor_id;