-
How can I use GROUP BY and ORDER BY in a single query?
Hi All,
How can I use Group By and Order By in a single query?
As I want to group the account records and ordered it by their id.
Thanks
-
1 Reply
-
Hello ,
You can use GROUP BY and ORDER BY in a single query. Here is the sample of Query :-
SELECT Name FROM Account GROUP BY name ORDER BY Name LIMIT 2
Thanks.
Log In to reply.
Popular Salesforce Blogs
Lightning Platform Mobile for Mobile App Development with Salesforce
Mobile has always had an effective and transformational impact on companies. But unfortunately, many companies face trouble delivering an intuitive user experience as a customer…
Things to Consider Before Deactivating a Salesforce Trigger
Introduction Triggers are an Apex script that runs before or after data manipulation language(DML), as an example, it invokes when we insert, deletes, update, merge,…
Here's How You Can Ease Operations for Your Non-Profit Organization: With a Salesforce Customer Portal
Salesforce's powerful customer portals give you the tools to keep your organization running efficiently and provide your members, donors, and customers with more self-service and…
Popular Salesforce Videos
Salesforce Customer 360 Data Manager
Salesforce Customer 360 Data Manager is a cross-cloud integration capability that allows Salesforce admins and developers to combine and reconcile customer data from their Salesforce…
How To Assign Leads in Salesforce | Overview of 3 Main Lead Routing Solutions
Salesforce offers several options on how to automatically assign incoming leads to a suitable sales manager. But what to choose: out-of-the-box features, external AppExchange app,…
Non-technical But Want to Build Career in Salesforce?
In this video Shrey gave the answer to the following questions: 1. What is the next step after doing Certification in Salesforce Administrator? 2. How…
