-
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, 7 months ago by
Ravi.
-
This discussion was modified 9 years, 5 months ago by Forcetalks.
-
This discussion was modified 9 years, 5 months ago by Forcetalks.
-
This discussion was modified 9 years, 7 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
Salesforce Implementation: In House vs Outsource
Introduction Salesforce is the leading cloud-based customer relationship management solution in the world, and it enables organizations to monitor and connect with current and potential…
Transforming Customer Engagement with Salesforce Experience Cloud: Best Practices
With high customer expectations in today's digital world, businesses must be at the forefront of customer engagement strategies. Salesforce Experience Cloud is the key to…
Device Detection With Devicedetect.js In Salesforce
A good responsive design in UI can render behaviour across different screen sizes. Though there are few edge cases in Salesforce development, especially where you…
Popular Salesforce Videos
Security in Salesforce | Security Levels in Salesforce
This 'Security in Salesforce' video by Edureka will help you understand the different levels of security in Salesforce. It will also talk about some of…
What are Roll-up Summary Fields in Salesforce? | How to create them?
In this video, Shrey is not only teaching but also demonstrating to you "What are Roll-up Summary Fields in Salesforce?". You will be learning: 1.…
MuleSoft Integration: Google Ads Lead Form to Salesforce - Learn Salesforce Series by Algoworks
MuleSoft integration: Google Ads lead form to Salesforce. In this video, learn how MuleSoft can be used to integrate Salesforce with Google Ads lead form.…
