-
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
ChannelOnline To Salesforce Integration [EPISODE-1]
We will complete this integration configuration into two phase. Phase 2 is available in EPISODE - 2. ChannelOnline offers customers the ability to integrate with Salesforce.…
How Cloud CRM Helps Automate Business Processes?
CRM software is the backbone of customer experience operations for most businesses today. In fact, the global market for CRM solutions is growing at a…
5 Reasons For Students To Become A Salesforce Developer
Salesforce CRM technologies have been an integral part of the world for quite a while now with more and more people coming to work in…
Popular Salesforce Videos
Auditing Account Deletion Using Salesforce Flow
This demo video walks through an example of Auditing Account Deletion Using Salesforce Flow Ever had an instance where users have accidentally deleted Accounts and…
How to Setup Salesforce Customer Community?
Step by step Salesforce tutorial for quickly setting up a Customer Community with Customer Service (Napili) Template.
Why Salesforce India is Primed for Growth
Amarendra Kumar, RVP of Alliances and Channels for India at Salesforce, says the region is poised for tremendous growth and opportunity over the next few…
