I want to filter out the contacts only if they have at least 1 serviceContract associated to it ?
I know this is possible using apex ( query all childs in inner query and iterate through using .size() operator.) But is there any alternate to put this condition in SOQL itselsf ?
Ex: Contact is a Parent and ServiceContracts are child to it.
Say, Can I have any alternate to this query ?
Select ID, (Select ID from ServiceContracts where size() >0) from contact limit 10