SQL - Query (SELECT)
Table of Contents
About
A query is a SQL statement that begins with the SELECT word.
A stored query is called a view.
The result of a query is stored in a result table, called the result-set.
A query is itself a Relations
Articles Related
Equal
- http://cosette.cs.washington.edu/ - Cosette is an automated prover for checking equivalences of SQL queries.
Type
Ad-hoc
Ad-hoc queries are query used to explore a data set and are therefore never known in advance.
Reporting
Reporting query are well-known query used to build metrics. See Data Analysis - Reporting Query