Consider the following SQL queries A and B
Query A :
select distinct course_id
from section
where semester = 'Fall' and year= 2017 and
course_id in (select course_id
from section
where semester = 'Spring' and year= 2018)

Query B:
select distinct course_id
from section
where semester = 'Spring' and year= 2017 and
course_id in (select course_id
from section
where semester = 'Fall' and year= 2018)

Question

Consider the following SQL queries A and B  
 Query A :  
 select distinct course_id 
 from section 
 where semester = 'Fall' and year= 2017 and 
 course_id in (select course_id 
 from section 
 where semester = 'Spring' and year= 2018) 
  
 Query B:  
 select distinct course_id 
 from section 
 where semester = 'Spring' and year= 2017 and 
 course_id in (select course_id 
 from section 
 where semester = 'Fall' and year= 2018)

Accepted Answer

Query A and B produce different results.

Answer

Query A and B produce the same results but the order differs.

Answer

Error in Query A, but Query B executes successfully

Answer

Error in Query B, but Query A executes successfully

Answer

Query A and B produce the same resultset

Crowdly

Consider the following SQL queries A and B Query A : select distinct cours...

Want instant access to all verified answers on moovit.vit.ac.in?