Basic SQL Query

• relation-list A list of relation names (possibly with a range-variable after each name).

• target-list A list of attributes of relations in relation-list

• qualification Comparisons (Attr op const or Attr1 op Attr2, where op is one of ) combined using AND, OR and NOT.

• DISTINCT is an optional keyword indicating that the answer should not contain duplicates. Default is that duplicates are not eliminated!

SELECT [DISTINCT] target-list

FROM relation-list

WHERE qualification

Previous slide

Next slide

Back to first slide

View graphic version