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