-
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
What are Validation Rules in Salesforce? | All You Need to Know
The main purpose of using the Salesforce Validation rule verifies that the data a user enters in a record meets the standards you specify before…
All You Need To Know About Salesforce & Quip Integration
When Salesforce bought Quip in 2016, users have been waiting for software upgrades that will boost collaborative and productive possibilities. Fortunately, these big integrations were…
Insert Record using JavaScript Remoting with Visualforce Page
Hey there! We must have heard about javascript remoting. So today we are going to learn about how to use the Javascript remoting to build…
Popular Salesforce Videos
Real-time Scenario: Custom Rollup Summaries Using Triggers | Salesforce Tutorial
Watch this video to learn all about Custom Rollup Summaries Using Triggers using the real-time scenarios. If you have any doubts or concerns do let…
How to Integrate Commerce, Marketing and Service Using Salesforce Customer 360
Developers, Integrators, Admins and Architects all work together to deliver projects that span multiple Salesforce products. Salesforce is making it simpler by providing native integration…
Set Your Sales Cloud Implementation Up for Success
Make Sales Cloud a valued business tool that your sales reps will rely on by starting with these planning strategies and best practices for success.…
