I am using a query to retrieve records in Workbench but everytime I run the query the number of records return is different. There are about 800000 records.
What would be the reason?
SELECT Opportunity.recordtype.name, LastModifiedDate, Id,Product_Name__c,Opportunity.CloseDate, CreatedDate FROM OpportunityLineItem
WHERE Opportunity.isclosed!= TRUE
AND (Opportunity.RecordType.Name = 'A' OR Opportunity.RecordType.Name = 'B')
ORDER BY OPPORTUNITY.ID