A simple query which gathers a subset of data from a table or tables.
A statement that specifies which data to retrieve from a database, as specified by your data model.
a standard query
a stored question about the data stored within the tables of your database
A query that returns rows into a result set from one or more tables. A Select query can contain specifications for the columns to return, the rows to select, the order to put the rows in, and how to group (summarize) information. Contrast with Delete query, Insert query, and Update query, all of which change data in a table.
The most common type of query, used to extract and associate fields from tables and other queries and present this data in datasheet format.
a query that selects a set of records from one or more tables based on some criteria