-
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 Administrator Responsibilities - What Needs to be Done and When
In this Top Salesforce Blog, we will be discussing Salesforce Administrator Responsibilities and what it is, what the profile talks about, what are the requirements,…
Get your development faster with Apex Code Assistance, Lightning Previewer and PMD Support for Apex in a new release of The Welkin Suite IDE
The Welkin Suite team just finished up its large push to hand out its latest Release for Windows, “Bloom R1”, as they continue toward their…
Salesforce Marketing Cloud Benefits in 2024
Contents Why choose the Salesforce Marketing Cloud? Key Benefits of Salesforce Marketing Cloud Personalization Multi-Channel Marketing Marketing Automation Data-Driven Insights Audience Segmentation Lead Management Scalability…
Popular Salesforce Videos
Understanding Pardot: The Ultimate Guide for Salesforce Admins
In this podcast, Andrea Terrell shares advice for Salesforce Admins on how they can level up their Pardot skills. She has a proven track record…
Salesforce Quickbooks Integration | eShopSync for Quickbooks
Product Sync? Invoice Sync? And more? eShopSync for Quickbooks brings out the best-class solution for Salesforce Quickbooks Integration. Click on the link to know more:…
Salesforce Business Analyst Training
In the 35th Episode of the #AskTheHulk series, Savitha Asked about how to switch to IT from Non-IT background. To this question, Shrey suggested that…
