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 vote275 views1 answer
Alter table add check constraint oracle
SQL
0 vote245 views1 answer
Order by monthly in sql
SQL
1 vote206 views1 answer
Oracle character set
SQL
5 votes274 views1 answer
Sql add column after another
SQL
0 vote250 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
0 vote256 views1 answer
Plsql find location of procedure
SQL
0 vote253 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote250 views1 answer
Find number of entries sql
SQL
0 vote261 views1 answer
Mysql check if lowercase
SQL
0 vote299 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL