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

How do you Integrate Salesforce with Alchemer?

Blog in Others

Salesforce is a popular customer relationship management (CRM) platform, and Alchemer is a survey and data collection tool. Formerly known as SurveyGizmo, the platform offers…

Alchemer Integration, Customer Experience, Customer Relationship Management, Integrate Salesforce, Integrate Salesforce CRM

ashutosh pandey Feb 27, 2023

1,269 Views

Five Common Misconceptions About Salesforce Person Accounts

Blog in Others, Salesforce

Salesforce is most popular for its administration position in B2B, however it additionally offers incredible arrangements in B2C and for our clients who offer to…

Account and Contact Objects, Administration Organizations, Administration Position, Administration Ventures, API Permits

Pooja Sep 1, 2020

4,735 Views

Getting Up-Close With The Future Of Salesforce’s Ever-Evolving Tech Ecosystem

Blog in Salesforce Ecosystem

“Change is the only constant.” - Heraclitus If any organization across the globe has truly lived by this saying, it is Salesforce. What began as…

Acquisitions of Salesforce, Acumen, AppExchange, Business, Business Operations

Grazitti Mar 3, 2022

1,969 Views

Salesforce Integration Cloud - Connect Devices, Data and Customers

Video in Salesforce Integration

Salesforce Integration Cloud incorporates an arrangement of services and tools that make it simple for clients to surface their information paying little attention to where…

Salesforce Integration, URL Mapping, Salesforce Data, Salesforce Commerce Cloud, User Experience

Abhay Apr 19, 2018

2,258 Views

Salesforce Beginner Interview Questions and Answers Full Length Video [2023]

Video in Salesforce Training, Salesforce Admin

Watch this video to get to know about Salesforce Beginner Interview Questions and Answers Full-Length Video [2023]. 00:00:00 Introduction 00:02:56 Sandbox 00:05:05 Process Builder 00:09:00…

Salesforce Training, Salesforce Tutorial, Salesforce Certification, Salesforce Developer, salesforce