-
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
Guide for Small Business: Unlocking Growth with Salesforce Pro Suite
In the evolving digital landscape, Salesforce for small businesses is not just a CRM platform; it's a growth accelerator, reshaping how SMEs connect with customers…
Learn About Salesforce Einstein Prediction Builder
The Einstein Prediction Builder can help you predict which opportunities will close and which goods prospects will buy. Predictions may be created based on the…
FAQs to Understand Salesforce Chatter Better
Salesforce Chatter is a social tool that helps professionals and companies work BETTER. The platform allows you to get brainstorm ideas, share loaded files, sites,…
Popular Salesforce Videos
Creation Of An App In Salesforce | Salesforce Development Tutorial
Creation of an app in Salesforce. This video will cover the following points - App Creation Get to know why an app is created. Configuration…
CEPTES’s successful visit to Dreamforce’17
Thank you all to those who visited CEPTES at Dreamforce’17. It had been a great event and CEPTES would like to offer gratitude to our…
Salesforce Tutorial - How to Create Custom App in Salesforce
Apps, Tabs, Objects are basic Building Blocks of Salesforce. In this video, I am explaining how exactly you will able to develop a custom app…
