-
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 10 years, 4 months ago by
Ravi.
-
This discussion was modified 10 years, 2 months ago by Forcetalks.
-
This discussion was modified 10 years, 2 months ago by Forcetalks.
-
This discussion was modified 10 years, 4 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
7 Essential Salesforce Hacks For Beginners
Salesforce CRM is an incredibly powerful tool for sales and customer relations. Through Salesforce you can manage customer details and sales prospects as well as…
3 Tactics to Optimize Your Salesforce Implementation
Salesforce implementation requires substantial planning and investment. While most businesses invest heavily during the implementation phase, only a significant proportion of them reap above satisfactory…
Get Salesforce Campaign Members Directly In MailChimp
For Email Marketing you have to add Salesforce Contacts directly into the MailChimp. So follow the steps to configure MailChimp for Salesforce and get the…
Popular Salesforce Videos
Smart Merchandising with Salesforce Einstein AI
Smart Merchandising is a holistic tool that magically combines rich insights from site-wide search, navigation, purchases, and the customer’s current session with strategic business goals.…
How to import data from Sage ERP to Salesforce - Part 1
Greytrix offers GUMU™ integration for Salesforce with Sage ERP systems - a best-of-breed solution for organizations to enhance their customer interaction. With Salesforce and Sage…
Salesforce Financial Services Cloud Implementation Guide
You’ve decided to use Salesforce Financial Services Cloud but where do you begin? How can you utilize Salesforce to track all your customer interactions and…
