When group by is used, how to write or use the where clause in soql ?
- 1 Answers
- 596 Views
- I also Faced
- E-Mail Answers
Answer / Awdhesh Kumar Gautam
You can include a WHERE clause when using GROUP BY in SOQL, but it must filter the data before the GROUP BY operation. The WHERE clause should come before the GROUP BY clause. For example: `SELECT Fields, COUNT(Id) FROM Object WHERE Condition GROUP BY Fields`
| Is This Answer Correct ? | 0 Yes | 0 No |
What were you doing before sfdc development?
What are the different ajax action tags? What does each do?
What are the benefits of the “one trigger per object” design pattern?
How to add a formula field to a salesforce report?
What is a junction object?
What is a Workflow Alert?
What is difference between datatable and pageblock table?
What is field-level security in salesforce ?
What is 'SOQL'?
When should you build solutions declaratively instead of with code?
What is Profile and Components?
What are the different ways to Share a record?
SAP 
