-
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 9 years, 9 months ago by
Ravi.
-
This discussion was modified 9 years, 7 months ago by Forcetalks.
-
This discussion was modified 9 years, 7 months ago by Forcetalks.
-
This discussion was modified 9 years, 9 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
Building Stronger Partnerships: How the Salesforce Partner Portal Empowers Success.
Building Stronger Partnerships: How the Salesforce Partner Portal Empowers Success The Salesforce Partner Portal is a powerful tool that empowers partners to build stronger relationships…
Sales Automation Guide To Boost Sales in Salesforce CRM
What is Sales Automation? A recent Salesforce report says that sales reps spend only 28% of their working hours actually selling. That means that two-thirds of their…
Hello World Code for Salesforce Einstein
As a programmer, We do code in many languages. We create always a program named as Hello World. This blog is all about for Hello…
Popular Salesforce Videos
Getting Turn by Turn Directions Between Scheduled Events | Salesforce Maps Mobile
Watch this video to learn how to get turn-by-turn directions between scheduled events in Salesforce Maps Mobile. 00:00 - Introduction 00:19 - Access your Schedule…
Apex Programming Tutorial for beginners : Data Types, Variables and Constants in Salesforce
Apex Programming Tutorial for beginners: Data Types, Variables and Constants in Salesforce.
How Salesforce Industries can Help Organizations to Save Millions?
Salesforce Industries i.e Vlocity empowers businesses with powerful platforms to boost collaboration and makes it easy to deliver great customer experiences. It provides tailored solutions…
