function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
kantravikantkantravikant 

Case in SOQL

Is it possible the "case" clause in salesforce?

So that for different picklist values ,we can aggregate the records distinguished in one soql query .

Best Answer chosen by Admin (Salesforce Developers) 
@anilbathula@@anilbathula@

Hi Ravi.kant,

 

Soql doesnot support 'case' clause.but u can acheive ur problem with some work around.

for that u can use this link as refernce.

http://boards.developerforce.com/t5/forums/forumtopicprintpage/board-id/apex/message-id/53643/print-single-message/false/page/1

 

Thanks

Anil.B