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 10 years, 3 months ago by Ravi.
- This discussion was modified 10 years, 1 month ago by Forcetalks.
- This discussion was modified 10 years, 1 month ago by Forcetalks.
Ajit replied 10 years, 3 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

What are Apex Triggers? | All You Need to Know

Blog in Salesforce Apex

Before reading this blog, you must have basic knowledge of Apex Language and SOQL. Apex triggers can invoke apex code and enable you to perform…

Apex Triggers, API Request, Before Trigger, Bulk Trigger, Custom Actions

Kapil May 9, 2023

1,691 Views

The Open Web Application Security Project | Salesforce Developer Guide

Blog in Others

OWASP (Zed Attack Proxy) is an Open-Source Web Application Security Extend. It is wanting to be used by both those unused to application security just…

Application Security, CSV Format, GUI Window, Java-based Device, Open Web Application Security

Marziya May 19, 2020

5,015 Views

Comparing Salesforce Orgs Since 2015: How BOFC Helped Define Metadata Management Before It Was a Category

Blog in Salesforce

Every Salesforce Admin eventually runs into the same question: two orgs, and no reliable way to know what's actually different between them. A sandbox drifts…

AppExchange, SaaS, saas-applications, Salesforce Admin, Salesforce Developer