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

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

Log In to reply.