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:
•
•
Specify a selection list that lists the columns to retrieve from one or more tables in your database.
•
•
•
•
•
Specify a subquery  within a SELECT statement.
•
Specify a restriction clause to restrict the rows Pervasive PSQL selects.