Applications

 

Query

A query is a structured request for information. It is used to retrieve information from database tables and views.

A query has several parts:

• A list of fields to be retrieved,
• a list of tables or views where to find these fields,
• a list of conditions the retrieved records must match,
• a list of sort criteria,
• restrictions of how many records are to be returned,
• and sometimes other parameters and options.

The result of a query is the result set, where each record contains the fields requested for one table row that matched the conditions.

Queries in OpenOffice.org Base are specified in Structured Query Language (SQL). There are three ways to create queries in OpenOffice.org Base. You can create a query using the query wizard, the design view or the SQL view.

Creating and Using Queries

The following screencasts demonstrate how to use queries:

• Create a new query using the design view.
• Create a new query using the SQL view.
• Rename a query.
• View the results of a query in a tabular form.
• Sort the query results by a field/column in ascending order.
• find a value in all fields of a query result set.

OpenOffice.org™ is a trademark of OpenOffice.org.