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