-
Will below query work? Explain. 1 SELECT COUNT(Id), Name, Address__c FROM Opportunity GROUP BY Name
Will below query work? Explain.
1
SELECT COUNT(Id), Name, Address__c FROM Opportunity GROUP BY Name -
1 Reply
-
Above query will throw an error.
Explanation : In Group by clause the columns selected must be either used in Group by clause or in aggregate functions. The Name field is neither used in aggregate methods and in group by clause and hence will result in error “Malformed Query”.
Log In to reply.
Popular Salesforce Blogs
Streamlining Operations of a Leading Bike Aggregator Through Salesforce® Field Service Lightning
Client Profile The client is a leading Bike Aggregator in the US, a start-up that has recently raised multi-million-dollar investment. They have a public-private partnership…
Salesforce Event Monitoring Unit - Getting Started
Event Monitoring Event monitoring allows you to trace plenty of events that occur on a Salesforce Org, for example, Authentication (Logins, Logouts), API Calls, Apex…
Our Top Picks From Salesforce Summer' 21 Pardot Updates
Another warm summer. Another feature-packed update by Salesforce. How do you make a good thing great? Simple. Provide meaningful, easy-to-implement updates and that is precisely…
Popular Salesforce Videos
How to Create Seamless Buying Experiences | Salesforce CPQ & B2B Commerce
B2B buying is evolving as buyers want a better, more personalized experience when shopping for their businesses. But Salesforce has that covered. Here are 4…
Kizzy Consulting - Top Salesforce Partner Intro Video
Kizzy Consulting is a Salesforce Consulting Partner and has successfully implemented 100+ Salesforce projects for 100+ clients across sectors like Financial Services, Insurance, Retail, Sales, Manufacturing,…
10 Example Future Method with Test Class | Asynchronous Apex | Salesforce Development Training Video
Salesforce uses a queue-based framework to handle asynchronous processes from such sources as future methods and batch Apex. This queue is used to balance request workload across…
