-
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
Set Up and Manage Salesforce Communities
Introduction Communities we create works as an important way of sharing information between people who are part of our business i.e. employees, partners, and customers.…
Profile Attributes in Salesforce Marketing Cloud
Steps to create a Profile Attributes in Salesforce Marketing cloud: Login to Marketing cloud Click on Email -----> Subscribers -----> Click on "Profile Management" Click…
Understanding Salesforce Permissions
Permissions in Salesforce can be dizzying. Between licenses, profiles, and permission sets, there are multiple ways permissions can be assigned, and multiple considerations you should…
Popular Salesforce Videos
Salesforce Developer No Code and Code - Extended Version
Here you will find a showcase of new technologies, tools, product news, and tutorials from Salesforce experts. Learn to build, automate, and scale on the…
Salesforce Data Management - Data Loader - Insert, Update, Upsert, Export, Delete
Use the Data Loader wizards to add, modify, or delete records. The upsert wizard combines inserting and updating a record. If a record in your…
WWE Connector for Salesforce
In this quick video we will show the Workspace Web Edition Connector for Salesforce. The WWE Connector leverage a powerful browser extension to guarantee a…
