Salesforce | Can I use ORDER BY and GROUP BY clause in the same query?

Tagged: Aggregate Query, Group By Clause, Order By Clause, Salesforce Error

Salesforce® Discussions

Can I use ORDER BY and GROUP BY clause in the same query?

Posted by Ravi on April 29, 2016 at 4:14 am
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 7 years, 12 months ago by Ravi.
- This discussion was modified 7 years, 10 months ago by Forcetalks.
- This discussion was modified 7 years, 10 months ago by Forcetalks.
Ajit replied 7 years, 12 months ago 2 Members · 1 Reply
1 Reply

Ajit

Member
April 29, 2016 at 6:47 am

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.

Popular Salesforce Blogs

Explore The Application Network | Salesforce Developer Guide

Blog in Others, Salesforce

Let’s Find Why Is Integration So Challenging? The Fourth(4th) technological revolution is upon us. Connectivity across people, applications, data, and therefore the Internet of Things…

360-degree View, 3rd Party Offerings, API Economy, API-drove Availability, API-Drove Network

MOHIT Dec 30, 2020

3,169 Views

Salesforce Data Cleansing Best Practices That you Should Consider Implementing Now

Blog in Data, Salesforce

Salesforce is a powerful tool that can help your business grow, but it can only reach its full potential when it’s populated with good quality…

Bad Quality Data, Best Practices, Business, Business Laders, Classic Experience

pogrebs Jun 5, 2020

12,011 Views

How to call Apex Method from Flow and Vice – Versa? | Salesforce Apex

Blog in Salesforce Apex

Spring '23 features that align with your core admin responsibilities. Release Highlights for Admins Salesforce Admins drive innovation with four core responsibilities: User Management, Data…

Apex, Apex Class, Apex Class Method, Apex Classes, Apex Code

SF Feb 28, 2023

1,196 Views

Which Certification Is Needed In Salesforce for Getting Job?

Video in Salesforce Training

Want to get a job in the Salesforce industry? Wondering which certifications are going to help. Join this useful group for Salesforce job & career…

Salesforce Training, Salesforce Tutorial, Salesforce Certifications, Salesforce Jobs, Salesforce Industry

Intelogik Sep 14, 2022

814 Views

5 Important Topics to Crack Salesforce Platform Developer 1 Exam

Video in Salesforce Certifications

In this video, Shrey gives you an important topic which gonna be really very helpful for crack the Platform Developer 1 Certification. Without mastering these…

Salesforce Tutorial, Salesforce Certification, salesforce platform, Platform Developer 1 Certification, Salesforce VIdeos