-
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, 6 months ago by
Ravi.
-
This discussion was modified 8 years, 5 months ago by
Forcetalks.
-
This discussion was modified 8 years, 5 months ago by Forcetalks.
-
This discussion was modified 8 years, 6 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
Choose the Right CRM: Checklist with 6 Tips on How to | Salesforce Guide
How do you choose the right CRM? The selection process can be overwhelming when there are hundreds of CRM solutions available. When it comes to…
How Salesforce Lightning Can Supercharge Your Marketing Strategy?
Salesforce Lightning is a powerful tool that can greatly enhance your marketing strategy and help you drive business growth and achieve your goals. In today's…
Learn About Einstein Activity Capture in Salesforce
This is a very important feature of the Sales Cloud. Using Einstein AI in Salesforce always helps sales reps to increase their performance and reach…
Popular Salesforce Videos
How to Create a New User in Salesforce Marketing Cloud
Cameron Robert steps through how to Create a New User in Salesforce Marketing Cloud and then assigns them Roles and Associates them with Business Units. Key…
How to Learn Salesforce Development | Salesforce learning steps for beginners | Trailhead demo
In this video, we shared the steps to learn salesforce lightning basics, salesforce apex development, CRM in online for free from scratch very quickly. Learn salesforce…
Salesforce Training | Salesforce Jobs For Beginners Video
Salesforce Training Tutorial video provides What is Salesforce and Salesforce jobs and Salesforce careers for beginners. So if you are planning to becoeme a Salesforce…