-
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
All That You Need to Know About Migrating to Salesforce CRM
There can be a number of reasons for companies to migrate from one CRM to another. While it indicates that a business is growing and…
What Slack and Salesforce Sales Cloud Could Do for Your Business
Today’s customers no longer prefer emails and phone calls. Customers anticipate continuous vendor assistance and participation. This means that reps must spend more time building…
How Variable Types Operate in the Lightning Component Framework
When writing a component or application, you can set an attribute to have a specific type. But how is the type being used by Aura,…
Popular Salesforce Videos
The Future of Salesforce App Dev with Parker Harris & Friends
Join Parker Harris, Salesforce product managers, and engineers as we kick off Day 2 of TrailheaDX with an in-depth look at exciting new features coming…
Lightning Flow – Release Readiness LIVE, Summer '20 | Salesforce
Watch this amazing video & join the Product Managers to see how you can build flows and processes more efficiently with enhancements to Flow Builder,…
Salesforce Development Master Training | Salesforce Development Course
Shrey Finally launched the most awaited Salesforce Development Master Training. Features of the course are: Learn Salesforce Development from Scratch with more than 100 on-demand…
