-
Explain difference in COUNT() and COUNT(fieldname) in Salesforce Object Query Language (SOQL).
Explain the difference in COUNT() and COUNT(fieldname) in Salesforce Object Query Language (SOQL).
-
2 Replies
-
COUNT()
COUNT() must be the only element in the SELECT list.
You can use COUNT() with a LIMIT clause.
You can’t use COUNT() with an ORDER BY clause. Use COUNT(fieldName) instead.
You can’t use COUNT() with a GROUP BY clause for API version 19.0 and later. Use COUNT(fieldName) instead.COUNT(fieldName)
You can use COUNT(fieldName) with an ORDER BY clause.
You can use COUNT(fieldName) with a GROUP BY clause for API version 19.0 and later -
COUNT(): It is an optional clause that can be used in a SELECT statement in a SOQL query to discover the number of rows that a query returns.This function returns the number of rows that match the filtering conditions and COUNT() must be the only element in the select list. The resulting query result size field which returns the number of rows and the records will return null.In simple words, COUNT() returns the number of items in a group, including NULL values and duplicates.
COUNT(fieldname):This function returns the number of rows that match the filtering conditions and have a non-null value records. An Aggregate Result object in the records field contains the number of rows. Do not use the size field for the resulting records.
Again in simple words, COUNT(expression) evaluates an expression for each row in a group and returns the number of non-null values.
Note: COUNT(Id) in SOQL is equivalent to COUNT(*) in SQL.
Log In to reply.
Popular Salesforce Blogs
Salesforce Custom Objects and Behavior - All You Need to Know
At the point when you make or empower highlights for a custom article, Salesforce makes elements to help your custom item. For instance, when you…
Introducing Trailhead ForceLeaderBoard API
Great power comes with great responsibility!!! Now its time to take your trailhead and certificate data to your platform. Just a simple API call and…
Should You Do Salesforce Backup — All You Need To Know
If you ever lost your data, you know how devastating it is. But what if this data affects the entire enterprise's functioning? Dealing with sensitive…
Popular Salesforce Videos
Salesforce Lightning Training
Here, the video is about the Salesforce Lightning Tutorial. These video covers comprise real-world projects that will introduce you to advanced concepts such as Lightning…
Time-based Workflow Rules In Salesforce | Salesforce Tutorial
Learn all about time-based workflow rules in Salesforce. This tutorial will cover the following points - 1. Create A Workflow Rule Learn how a workflow…
How to Manage Your Data and Contacts in Salesforce Marketing Cloud
Learn how contacts are counted and how data is structured in Marketing Cloud. This video explores how Marketing Cloud receives data from many sources and…
