-
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
Salesforce Shield Platform Encryption Guide
Shield Platform Encryption As organizations store more sensitive data, like actually recognizable data (PII), in the cloud, they need to guarantee the protection and classification…
Send OTP Using Login Flow | Salesforce Developer Guide
Two-factor authentication is the best path to employ for high standards security. This method includes adding a second factor to the login and password, with…
Top 7 Reasons Companies Choose Salesforce Consulting Services for Growth
In the current highly competitive business environment businesses are constantly under the pressure to deliver superior customer experiences, simplify processes, and boost growth. Salesforce, the…
Popular Salesforce Videos
How to Become Salesforce Certified Architect: Achieve More Under Pressure
Achieve more under pressure: CTA Edition How to become Salesforce Certified Architect 0:00 Introduction 5:21 What is CTA exam about 10:37 What is CTA Exam…
Data Cleansing in Salesforce and Salsa - Why it matters?
Research by Blackbaud found that 67% of data available to some nonprofits were un-mailable. That is either a lost opportunity or wasted money. This especially…
Tips for Importing Data in Salesforce
Data can be easily imported into Salesforce through various tools provided by Salesforce. Supported data sources include any program that can save data in the…
