SOQL group by & roll up example

SELECT Status__c, count(name) cnt FROM Commercial_Contract__c
WHERE Status__c NOT IN (‘Rejected’,’Draft’,’Void’,”) AND Status__c != null
GROUP BY ROLLUP (Status__c)

Print Friendly, PDF & Email
This entry was posted in Soql. Bookmark the permalink.