-
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 10 years, 5 months ago by
Ravi.
-
This discussion was modified 10 years, 3 months ago by Forcetalks.
-
This discussion was modified 10 years, 3 months ago by Forcetalks.
-
This discussion was modified 10 years, 5 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
Salesforce Demand tool: Data Quality & Data Cleaning
Hi all, As you all know about the Demand tool which is used for Salesforce data cleaning and maintaining its quality. In this article, you…
Salesforce Dynamic Forms: Overview, Benefits, Business Cases
On a user page layout in Salesforce might be placed a monolit block of fields which makes customization impossible. The task of Dynamic Forms is…
Why ISVs Must Strive Harder To Be On AppExchange?
Are you on Salesforce AppExchange? How many apps do you have on Salesforce AppExchange? If you are an ISV then you must be pretty aware…
Popular Salesforce Videos
What is Salesforce? What Does it Do?
Business is rapidly changing. In this digital age, everything and everyone is connected, which is changing the way we communicate with our consumers. Businesses nowadays…
Salesforce Anywhere – Release Readiness LIVE, Spring '21
Salesforce, the global leader in CRM, introduced Salesforce Anywhere – bringing together powerful new technologies and platform services to help organizations unlock new levels of…
Salesforce AppExchange Pricing Models
Salesforce AppExchange offers a wide range of solutions and applications designed to enhance and extend the functionality of Salesforce. However, understanding the pricing models can…
