-
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
Displaying Field According to Its Datatype In Salesforce Lightning Component
For my recent Requirement, I had to show the LookUp field of inside a lightning component. I had to use two components, the parent and…
Salesforce Gmail Integration: Seamless Communication
As a continuously growing business and an esteemed Salesforce partner, we know and understand the importance of productivity. Time is a valuable resource that we…
SuiteWorld 2024: Everything You Need to Know
Table of Contents for "SuiteWorld 2024: Everything You Need to Know" Introduction What Is NetSuite SuiteWorld? Where Will SuiteWorld 2024 Be Held? How Much Is…
Popular Salesforce Videos
Salesforce Guide to Sharing Architecture
The Salesforce sharing model is an essential element in your organization's ability to provide secure application data access. Therefore, it's crucial to architect your sharing…
Everything New in Salesforce Developer Tools
Your productivity starts and ends with the tools you use. Learn how Salesforce Developer Tooling can help you collaborate more effectively with your whole team.…
What are The Benefits of Salesforce Financial Services Cloud?
Business today is all about relationships. That’s nothing new. But how you go about managing and maintaining those relationships is completely different in today’s business…
