-
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 8 years, 7 months ago by
Ravi.
-
This discussion was modified 8 years, 6 months ago by
Forcetalks.
-
This discussion was modified 8 years, 6 months ago by Forcetalks.
-
This discussion was modified 8 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 Einstein AI: How it works for Service Cloud?
In our time, not using the advantages of digital automation for business is like moving on a cart wrapped in horses in a race while…
What is Marketing Cloud? Know the Features and Benefits for Businesses
The era of digitization is surging with the evolution and advancements of technologies. Gone are the days when businesses used to rely only on a…
Saving Journey History in Salesforce Marketing Cloud
Salesforce Marketing Cloud allows you to set your contacts on a marketing journey with timed communications and logic-based actions. It also gives you the ability…
Popular Salesforce Videos
Salesforce Developer Training Videos For Beginners | Salesforce Training
This Salesforce Training Video is the video session of a live virtual class conducted by Simplilearn. So if you just go through the video you…
The future of Salesforce Lightning (according to Mike Rosenbaum)
We find out from Mike Rosenbaum (@mike945778) who is in charge of Salesforce Sales, Service & Lightning, the future of Salesforce Lightning at the London…
How to Create an Object in Salesforce Lightning Experience?
Salesforce has always emphasized on declarative development since the beginning. The motto is that enterprise software should be easy to use for customers. With “clicks…