Database Reference
In-Depth Information
An alternate syntax of the
SELECT
statement as described in [Date, 2004] follows:
As you will soon see, this syntax is much closer to the actual implementation in SQL.
Example1b:
To select all students enrolled in program B.Sc. in MIS, the following
statement (based on the Date notation) would apply:
7.3.2 Projection Statement
Based on the Ullman notation, the
PROJECT
statement is of the form
Example 2a:
The following are two projections on the relation
Student