Укажите запрос (или запросы), который найдет пересечение идентификаторов студентов, получавших и 2, и 5. Каждый идентификатор из пересечения должен встречаться не более одного раза!

Question

Answer

SELECT StudentId FROM EXAM_RESULT WHERE GRADE = 2  
 UNION 
   ALL SELECT StudentId FROM EXAM_RESULT WHERE GRADE = 5

Answer

SELECT StudentId FROM EXAM_RESULT WHERE GRADE = 2  
 UNION 
  SELECT StudentId FROM EXAM_RESULT WHERE GRADE = 5

Answer

SELECT StudentId FROM EXAM_RESULT WHERE GRADE = 2  
 INTERSECT 
  ALL SELECT StudentId FROM EXAM_RESULT WHERE GRADE = 5

Answer

SELECT StudentId FROM EXAM_RESULT WHERE GRADE = 2  
 JOIN 
  SELECT StudentId FROM EXAM_RESULT WHERE GRADE = 5

Answer

SELECT StudentId FROM EXAM_RESULT WHERE GRADE = 2  
 INTERSECT 
  SELECT StudentId FROM EXAM_RESULT WHERE GRADE = 5

Crowdly

Укажите запрос (или запросы), который найдет пересечение идентификаторов студент...

Want instant access to all verified answers on lms.itmo.ru?