Database Reference
In-Depth Information
Example 3:
List all students, (names and ID#) who share surname with other
students.
Note:
The QUEL verb RETRIEVE describes retrieval. The pure calculus follows the
RETRIEVE verb. Also note that the original QUEL did not use a semicolon to punctuate
statements. It is done here simply to improve readability.
Example 4a:
List all programs (showing Pgm#) that include the course M100.
Example 4b:
List all programs (showing Pgm# and PgmName) that include the
course M100.
Example 5:
List all program codes and related course codes.
Example 6:
List all program names and related course names.