-
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
Salesforce Configuration Vs Salesforce Customization and Their Best Practices
What Is Configuration In Salesforce? Salesforce design is everything you can do inside the CRM framework. This implies you can add another field to your…
Salesforce and Workday Collaboration: Launching a Joint AI Initiative
Salesforce and Workday partnership, two leading cloud-based platforms, have announced a strategic partnership that brings together their strengths in AI and data management. This alliance…
Salesforce Editions Comparison: Choosing the Right Edition for Your Business
A Detailed Walkthrough of Salesforce Editions Comparison Salesforce offers multiple CRM editions like Essentials, Professional, Enterprise, and Unlimited – each of these Salesforce editions are…
Popular Salesforce Videos
Salesforce Developer Training Videos For Beginners | Salesforce Training Videos | Edureka
This Salesforce developer training video will give you an introduction to the development aspects of Salesforce. You will learn how Visualforce pages are created by…
5 Reasons To Choose Marketing Automation For Your Business | Salesforce
With the advancement in technology, it has become imperative to move towards more advanced methods to grow your business. Marketing automation is one method that…
How you can Increase your Salesforce Efficiency and Productivity
In this video, Brad discusses how to increase your workplace efficiency and productivity using various Google Chrome extensions and techniques. As always, we have linked…
