-
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, 6 months ago by
Ravi.
-
This discussion was modified 10 years, 4 months ago by Forcetalks.
-
This discussion was modified 10 years, 4 months ago by Forcetalks.
-
This discussion was modified 10 years, 6 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
Best Practices for Change Sets in Salesforce
These are some of Best Practices for Change Sets:- Deploy each dependent components Make sure every outbound change set contains all mutually beneficial parts that…
What Does The Future Hold For Salesforce?
As one of the most exciting Cloud platforms around, the Salesforce suite of applications is beginning to find widespread applicability in a rapidly increasing number…
3 Hot Trends Secretly Pointing towards Future of CRM
Customer Relationship Management or CRM is the future of the business and is not going to fed so soon. Starting from small businesses to the…
Popular Salesforce Videos
TrailheaDX '18 Opening Keynote - Part 6: Skill Up Everyone
Related Videos: Salesforce TrailheaDX ’18 Opening Keynote – Part 1: Create Connected Customer Experiences TrailheaDX ’18 Opening Keynote – Part 2: Salesforce Platform TrailheaDX ’18…
Salesforce Admin Tutorial for Beginners 2022
Complete Salesforce Admin Tutorial 00:00:00 Salesforce - Introduction 00:01:27 Salesforce - Types of Services 00:02:21 Salesforce - Cloud Services 00:07:51 Salesforce - Developer Account 00:16:09…
Introduction to SFDX Deploy Tool for Windows | Salesforce Integration Tutorial Series
In this tutorial, we're going to learn about SFDX Deploy Tool for Windows. SFDX Deploy Tool helps you to deploy metadata from one Salesforce org…