-
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
5 Salesforce Lightning Features You're Missing Out On
Personalities praised for being bold, unique and intuitive deserve a working environment that reflects the same. Salesforce has transitioned from data entry focused on workflow…
How to Use "WORKBENCH" with Salesforce!
Workbench is a tool designed for administrators and developers to connect with Salesforce organizations. Salesforce Workbench provides support for the Force.com Partner, Bulk, Rest, Streaming,…
All you Need to Know About No Code Salesforce and Aircall Integration
If you're looking for a way to improve your customer service and sales process, you should consider integrating Aircall with Salesforce. Aircall is a cloud-based…
Popular Salesforce Videos
2020 Salesforce Admin Certification - Lightning Knowledge Base Setup
A Salesforce Admin Certification is the highest form of recognition a Salesforce Administrator can achieve; it demonstrates expertise in the field as well as a…
How to Create Seamless Buying Experiences | Salesforce CPQ & B2B Commerce
B2B buying is evolving as buyers want a better, more personalized experience when shopping for their businesses. But Salesforce has that covered. Here are 4…
9 Stages of Identity & Access Management Lifecycle | Salesforce Tutorial
Grow your architect skills and expertise in the area of Identity and Access Management. This video explains the 9 stages of Identity & Access Management…