SQL Query

• relation-list: A list of relation names (+ optional range-variables)

• target-list: A list of attributes to be retrieved

• condition: Comparisons 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 condition

Previous slide

Next slide

Back to first slide

View graphic version