Select columns of a typed table

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)
⋮