-
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, 8 months ago by
Ravi.
-
This discussion was modified 9 years, 7 months ago by Forcetalks.
-
This discussion was modified 9 years, 7 months ago by Forcetalks.
-
This discussion was modified 9 years, 8 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
All You Need to Know About Apex Test Class in Salesforce
You may create and run tests for your apex classes and triggers on the lightning platform using the apex testing framework. Apex unit tests help…
Salesforce Security Mastery: Object, Permission Sets, Field, and Record-Level Strategies with OWD
What You’ll Learn: How to protect an Object in Salesforce Security? What is Profile Level Security? What is Permission Set in Salesforce? Difference between Profile…
Streamline Product Roadmap through Salesforce Service Cloud and Jira Integration
Being a product manager has its perks, but the job also has its challenges. Most of the time goes into product road-mapping and coordinating with…
Popular Salesforce Videos
Things You Must Know About Salesforce Desk.com
Salesforce Desk.com is an all-in-one customer support application which is completely cloud based and which gives you the ability to buy services on per agent…
Use Salesforce CMS to Manage and Publish Content for Experience Cloud Sites
Learn how Salesforce CMS helps you create, manage, and publish your content in Experience Cloud. With Salesforce CMS, you can also customize content for specific…
Salesforce Lightning Development | Make Your Business Lightning-Ready With Algoworks!
Description - From creating Lightning-ready Salesforce AppExchange apps to making Salesforce instances Lightning-ready, we have mastered Lightning. Contact us for salesforce lightning development services! https://www.algoworks.com/salesforce/…