-
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 Launched Marketing Cloud For Nonprofits
Recently, Salesforce introduced Marketing Cloud for Nonprofits to assist them in creating more personalized experiences for their donors quickly and efficiently, regardless of where they…
Types of Salesforce Support (Customer Success) Plans You’ll See out in the Wild
Customer success is when the customers can achieve their desired business outcomes by leveraging the Salesforce platform. Providing a suitable customer success plan means providing…
Salesforce Code Builder is Officially Released
Salesforce Code Builder has been officially released and is now generally available, offering a new web-based integrated development environment (IDE) that seamlessly incorporates open, modern,…
Popular Salesforce Videos
Knowledge Base in Salesforce Lightning
By end of this video, we will be able to 1. Understand what is knowledge base. 2. Why we need to use Knowledge base 3.…
Salesforce Connections 2018 Keynote - Ch. 2: Ticketmaster Is A Trailblazer
Salesforce Connections 2018 Keynote – Ch. 1: Corporate Positioning Salesforce Connections 2018 Keynote – Ch. 2: Ticketmaster Is A Trailblazer Salesforce Connections 2018 Keynote –…
How to Configure SAML Single Sign-On with Salesforce as the Identity Provider
Configure single sign-on with a Salesforce org as the identity provider for an external Heroku app acting as the service provider, using SAML. Watch this…
