• Kevin Garcia 12
  • NEWBIE
  • 0 Points
  • Member since 2022

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 8
    Replies
Hello, I am trying to perform a SOQL query in Salesforce. 

currently, when I search this query: 

select Id, Account.Id, Account.WBCNumber__c from Opportunity
WHERE FiscalQuarter__c = 'Q2 2020'
and 
AccountBoxoutNumber__c IN ('1-1206799572','1-1206525485','1-1206525485')

I only receive two values because the last two AccountBoxoutNumber values are repeating in the query. is there a way to make SOQL provide me with unique values even when there are repetitions in the Query?
 
Hello, I am trying to perform a SOQL query in Salesforce. 

currently, when I search this query: 

select Id, Account.Id, Account.WBCNumber__c from Opportunity
WHERE FiscalQuarter__c = 'Q2 2020'
and 
AccountBoxoutNumber__c IN ('1-1206799572','1-1206525485','1-1206525485')

I only receive two values because the last two AccountBoxoutNumber values are repeating in the query. is there a way to make SOQL provide me with unique values even when there are repetitions in the Query?