---
schema_version: "1"
id: 24c518c3fe0dae34c270b16213fe68b64d0fbe6f7a6fe63c230b1632eb42bc13
title: GROUPING( fieldName ) )
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/platform/salesforce-soql-sosl/guides/soql-sosl/sforce-api-calls-soql-select-grouping.md
canonical_url: https://developer.salesforce.com/docs/platform/salesforce-soql-sosl/guide/sforce-api-calls-soql-select-grouping.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: a5d88c21d1c296ce33cb158c7ba27c3e2a3129a90b0c9eb799bd4e70bffb4280
products:
  - SOQL and SOSL Reference
  - Platform Developer Content
---

# GROUPING( fieldName ) )

You can use the `GROUPING(fieldName)` function in `SELECT`, `HAVING`, and `ORDER BY` clauses.

Use the `GROUPING(fieldName)` function to determine whether a row is a subtotal or field when you use `GROUP BY ROLLUP` or `GROUP BY CUBE` in SOQL queries.

`GROUPING(fieldName)` returns `1` if the row is a subtotal for the field, and `0` otherwise.

<!-- otherprops: set_clipboard -->

```soql
SELECT LeadSource, Rating,
    GROUPING(LeadSource) grpLS, GROUPING(Rating) grpRating,
    COUNT(Name) cnt
FROM Lead
GROUP BY ROLLUP(LeadSource, Rating)
```

For more details, see [Identify Subtotals with GROUP BY](https://developer.salesforce.com/docs/platform/salesforce-soql-sosl/guide/sforce-api-calls-soql-select-groupby-grouping.md).