next up previous
Next: The select Clause Up: SQL Previous: Background

Basic Structure

  1. Basic structure of an SQL expression consists of select, from and where clauses.
  2. Typical query has the form

     select  tex2html_wrap_inline1726 

    from tex2html_wrap_inline1728

    where P

    where each tex2html_wrap_inline1730 represents an attribute, each tex2html_wrap_inline1732 a relation, and P is a predicate.

  3. This is equivalent to the relational algebra expression


Osmar Zaiane
Fri May 22 19:39:12 PDT 1998