A query is a user's request for information to be retrieved from a database. A query consists of the following parts:
As an example, let us examine, using databases, what queries contain information about books. Assume that we have the following information about every book: Title, Author, Number of pages, Publication date, and Year of purchase. In this case, a query would be a formal description of such expressions as follows:
Example 1. I want to get from the database a list of books written in 1995, sorted by name. Where:
Example 2. I want to get from the My Favorite Books folder a list of the books published in the year of creation, the number of pages of which is greater than 200, grouped by author, where:
Example of displaying query results:
Queries can also be used to change records and create Recordset variables.
Copyright (C) 2001-2010 Binary Brilliant Inc. All Rights Reserved.