-
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 Implementation Checklist: 9 Steps to Success
Through it all, Salesforce continues to remain one of the largest players and one of the best platforms in the market. But we all know…
Where is Salesforce DevOps Heading? Is it the Future, and if so How?
Salesforce DevOps is distinct. It enables efficiency and collaboration among shareholders that some other platforms just cannot provide. It’s not as if DevOps is extremely different from…
15 Salesforce Admin Tools You Must Have for a Smooth Workflow
You need the most powerful and impactful Salesforce admin tools and tech help to automate your workflow, maximizing productivity. In a tech world, you must…
Popular Salesforce Videos
Slack and Salesforce integration for Sales
Learn how you can extend your Salesforce investment to boost productivity and simplify collaboration across sales teams. See how teams can instantly get notified of…
How can Salesforce Field Service Help in Providing a Better Customer Experience?
Salesforce Field Service Management automates and optimizes the work of field service workers (agents, dispatchers, mobile technicians). It is part of the Service Cloud and…
PASS Salesforce Certified Administrator Exam on the FIRST Attempt
Want to pass the Salesforce Certified Administrator Exam on the FIRST Attempt? Then this video is for you. Here are the steps: STEP 1 :…
