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

1 vote127 views1 answer
Python escape string for sql
SQL
0 vote163 views1 answer
Postgresql newline character
SQL
0 vote177 views1 answer
Flask sqlalchemy decimal
SQL
1 vote167 views1 answer
Oracle explain plan
SQL
0 vote130 views1 answer
Get last run query sql server
SQL
1 vote172 views1 answer
Mysql best tutorial for beginners
SQL
0 vote193 views1 answer
Mysql into outfile with headers
SQL
0 vote134 views2 answers
Avg() sql
SQL
0 vote163 views1 answer
Commit transaction sql
SQL
0 vote169 views1 answer
Starting mysql shell lampp ubuntu
SQL