-
Can I use ORDER BY and GROUP BY clause in the same query?
Can I use ORDER BY and GROUP BY clause in the same query? I am getting an unknown parsing error when using both clause in my query.
-
This discussion was modified 9 years, 11 months ago by
Ravi.
-
This discussion was modified 9 years, 9 months ago by Forcetalks.
-
This discussion was modified 9 years, 9 months ago by Forcetalks.
-
This discussion was modified 9 years, 11 months ago by
-
1 Reply
-
SELECT Name,MAX(Test__c) FROM Account GROUP BY name ORDER BY name LIMIT 2
Field that are aggregated cannot be used in GROUP BY or ORDER BY.
In the above example, Test__c cannot be used in GROUP BY or ORDER BY because Test__c is aggregated.
Log In to reply.
Popular Salesforce Blogs
5 Ways Salesforce CPQ can Transform Your Sales Process
You understand the value of streamlining your sales process as a salesman. You can spend more time completing business if you spend less time making…
Send Salesforce Record Data {as Email functionality} via WebMerge
WebMerge is a great platform that allows our data to populate different types of documents and send it to various other platforms or contact automatically…
Salesforce Introduces Einstein Automate
Salesforce introduced Einstein Automate on December 2nd 2020. Salesforce had a number of shocking announcements for their customers in December – acquiring Slack for $27.7 B, introducing Hyperforce, and a…
Popular Salesforce Videos
What is CRM and How Does it Work? | Salesforce
What is CRM (Customer Relationship Management) and how does CRM work? Watch this video to see how CRM helps you keep track of everything about…
Salesforce Certifications 2022 | Which Certifications You Need & Why You Need Them
If you’re looking to start a Salesforce job this year you’re going to need a Salesforce certification. But where do you start, which certification should…
Benefits of Implementing Salesforce Revenue Cloud
Healthy revenue growth is a vital indicator of a firm’s success. The key aspects that majorly affect an organization’s revenue growth are sales, operations, finance,…
