A query on a typed table is no different from a query
on any other table. For example, the following query uses the asterisk
symbol (*) to specify a SELECT statement that returns all columns
of the employee table. Figure 1: Query
SELECT * FROM employee
The SELECT statement on the employee table returns
all rows for all columns. Figure 2: Query result
name Paul, J.
address ROW(102 Ruby, Belmont, CA, 49932, 1000)
salary 78000
name Davis, J.
address ROW(133 First, San Jose, CA, 85744, 4900)
salary 75000
⋮
The following query shows how to construct a query that
returns rows for the name and address columns of the employee table. Figure 3: Query
SELECT name, address FROM employee
Figure 4: Query result
name Paul, J.
address ROW(102 Ruby, Belmont, CA, 49932, 1000)
name Davis, J.
address ROW(133 First, San Jose, CA, 85744, 4900)
⋮