---
schema_version: "1"
id: 6b6451f23f47b4494e315f9b89ba67567b08325ad33654ae72297162c8b91965
title: EVERY
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-query-guide/references/data-cloud-sql-reference/aggregate-func/every.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/every.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: faecfd77fd145850a21bbbd83e5093b87939501c8fc21f607a5c93e80855c795
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# `EVERY`

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

Returns true if all input values are true; otherwise returns false. Equivalent to `BOOL_AND`.

## Syntax

```sql
every(<expression>)
```

## Arguments

### Required

- `<expression>`: An expression of type `boolean`.

## 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.

```sql
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.

```sql
SELECT vendor_id, every(is_verified) AS all_verified
FROM products
GROUP BY vendor_id;
```

## Related Documentation

- [BOOL_AND](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/bool-and.md)
- [BOOL_OR](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/bool-or.md)
- [Aggregate Functions](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/aggregate.md)