Where clause for child record apex

Select C1, C2 from A 
where 
ID in (Select ParentId from B where Status__c='Completed') 
and 
Id NOT IN (Select ParentId from Opportunity where Status__c <> 'Completed')

Source: salesforce.stackexchange.com

Similar codes

0 vote276 views1 answer
Sql database connectivity
SQL
0 vote284 views1 answer
Mysql coonect sample code
SQL
0 vote279 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
9 votes312 views3 answers
Pyodbc connect to sql server
SQL
0 vote291 views1 answer
Vowels in sql
SQL
0 vote285 views1 answer
Leftjoin in sql
SQL
12 votes288 views4 answers
Mysql ifnull
SQL
12 votes290 views1 answer
Script to add new column in table sql
SQL
0 vote284 views1 answer
Mysql foreach insert
SQL
0 vote280 views1 answer
How to open mysql in docker
SQL