GITTA-Logo
PDF Version of this document Search Help

Lesson Navigation IconAnfragesprache SQL

Unit Navigation IconSQL Overview

Unit Navigation IconBasic database queries

LO Navigation IconSelect-From-Where

LO Navigation IconMultiple conditions

LO Navigation IconComplex conditions

LO Navigation IconArithmetische Operatoren

LO Navigation IconNon-relational constructs

LO Navigation IconSet operators

LO Navigation IconUsage of SQL

LO Navigation IconDatabase queries

Unit Navigation IconSQL Insert, Delete and Update

Unit Navigation IconSummary

Unit Navigation IconRecommended Reading

Unit Navigation IconBibliography

Unit Navigation IconMetadata


GITTA/CartouCHe news:


Go to previous page Go to next page

Set operators

Set operators are used to connect different queries and produce a resulting relation. Of course these set operations are only allowed if the attributes match (eg. the domain or the number of attributes etc.). The following set operators are used to join together sets of tuples. They might already be known from the algebra of sets.

  • union produces a union of different sets
  • intersect produces an intersection of different sets.
  • minus subtracts one set from another one.
Set operators

This query is used to find all names of customers who have a magazine subscription and who have placed an advertising in this magazine.

Top Go to previous page Go to next page