-
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
Ways to Optimize Your Salesforce Org in Business
Observing end-client appropriation and wiping out specialized obligations are the two foundations for developing a hearty CRM-compelling Salesforce organization, yet in the event that you…
What is Salesforce Net Zero Cloud?
Barely a day goes by without there being something in the news about climate change, sustainability or carbon footprints. It is a major focus for…
Top 5 Accounting Software For Salesforce
Salesforce unlocks the door to opportunities for better customer relationships and engagement. Businesses working on Salesforce might face difficulties in handling income, expenses, cash flow,…
Popular Salesforce Videos
Developer Life in India | An Interview with Salesforce Chef
Timecode: 00:00 Introduction 01:10 Who is Amit Singh? 01:56 Amit has interesting projects 03:58 Amit does technical content, but he is still popular. How? 05:45…
Salesforce Consent Management
Consent Management: Track Customer Consent and Honor Opt-Out Requests. Track your customers' approval for how your company interacts with them. To help you assess your…
Summer Internship | Career with Salesforce
This Summer, dive into the ocean of Salesforce with S2 Labs Apply for the much-awaited S2 Labs Summer Internship Program and start accelerating your career…
