Overview of Retrieving Data
Once your database contains data, you can retrieve and view that data using a SELECT statement. Pervasive PSQL returns the data you request in a result table. Using SQL statements, you can do the following:
•
Create temporary views or permanent (stored) views.
•
Specify a selection list that lists the columns to retrieve from one or more tables in your database.
•
Specify how to sort the rows.
•
Specify criteria by which to group the rows into subsets.
•
Assign a temporary name (alias) to a table.
•
Retrieve data from one or more tables and present the data in a single result table (a join).
•
Specify a subquery  within a SELECT statement.
•
Specify a restriction clause to restrict the rows Pervasive PSQL selects.