-
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
Campaigns now come to Lightning. But I have got issues
Salesforce Lightning Experience was launched in Winter16 release almost 6 months back. And even after that much time i am still clinging on to Classic…
7 Tips to Boost Productivity with Salesforce Insurance Solutions
Salesforce for insurance companies is a powerful tool for managing your business. However, it's not always easy to use or understand the implications of using…
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…
Popular Salesforce Videos
MuleSoft Integration: Salesforce Event with AWS MySQL Database
Learn how to integrate Salesforce Event with AWS MySQL Database using MuleSoft. The video will cover these four points - 1. Introduction Integrating Salesforce and…
Schedule Batch Apex | Asynchronous Apex in Salesforce | Learn Salesforce Development
Watch this video tutorial to learn how to schedule batch apex in Salesforce. If you have any doubts or concerns do let us know in…
Why iCompliance Trusts TechForce Services for Salesforce Managed Services | Client Testimonial
At iCompliance, delivering trusted AFSL compliance services requires seamless operations and efficient technology. That’s why they turned to TechForce Services for Salesforce Managed Services. In…
