如何在 SOQL 中將日期照著年份或月份分組 How to group by year or month in SOQL?

範例

SELECT count(id), CALENDAR_YEAR(createddate )  FROM Opportunity 

group by CALENDAR_YEAR(createddate ) 

其它你可能不知道但很好用的 SOQL 函數

• Count_Distinct()
• HOUR_IN_DAY()
• GROUPING() <---用來算 subtotal 的

參考資料

• Aggregate Functions
  https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_agg_functions.htm
• Date Functions
  https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_date_functions.htm