Salesforce
PDII · Question #222
A company has a custom object, Order__c, that has a custom picklist field, Status__c, with values of 楴ew', 業n Progress', or 楩ulfilled' and a lookup field, Contact__c, to Contact. Which SOQL query…
The correct answer is C. SELECT Id FROM Contact WHERE Id NOT IN (SELECT Contact__c FROM Order__c WHERE. See the full explanation below for the reasoning.
Question
A company has a custom object, Order__c, that has a custom picklist field, Status__c, with values of 楴ew', 業n Progress', or 楩ulfilled' and a lookup field, Contact__c, to Contact. Which SOQL query will return a unique list of all the Contact records that have no 楩ulfilled' Orders?
Options
- ASELECT Id FROM Contact WHERE Id NOT IN (SELECT Id FROM Order__c WHERE Status__c =
- BSELECT Contact__c FROM Order__c WHERE Status__c <> 'Fulfilled'
- CSELECT Id FROM Contact WHERE Id NOT IN (SELECT Contact__c FROM Order__c WHERE
- DSELECT Contact__c FROM Order__c WHERE Id NOT IN (SELECT Id FROM Order__c Where
How the community answered
(32 responses)- A3% (1)
- B16% (5)
- C75% (24)
- D6% (2)
Community Discussion
No community discussion yet for this question.