1.2.1 Example: Retrieve customer information for all customers

Retrieve all rows from the customer table (USERSLIST) and display the results. The customer table consists of columns for customer ID (USERID), name (NAME), and sex (SEX).

Table to search

Specification example

SELECT "USERID","NAME","SEX"
    FROM "USERSLIST"

Retrieval results

Note

To retrieve all columns of a table, you can specify an asterisk (*) instead of the column names. The following is an example.

Specification example

SELECT * FROM "USERSLIST"

Retrieval results

To Page Top