SQL Reference

Department of Computer Science - Randolph-Macon College

Professor Necaise

 

Set Operations

Join QueriesSQL ReferenceAggregate Functions

Set Union

  SELECT student_id FROM sports UNION
     SELECT student_id FROM clubs;

Set Intersection

  SELECT student_id FROM sports INTERSECT
     SELECT student_id FROM clubs;

Set Difference

  SELECT student_id FROM student EXCEPT
     SELECT student_id FROM sports;

Set Comparison



Join QueriesSQL ReferenceAggregate Functions
Print -- Recent Changes
Page last modified on February 18, 2014, at 12:11 PM