SQL - Query (SELECT)
Table of Contents
1 - 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
2 - Articles Related
3 - Equal
- http://cosette.cs.washington.edu/ - Cosette is an automated prover for checking equivalences of SQL queries.
4 - Type
4.1 - Ad-hoc
Ad-hoc queries are query used to explore a data set and are therefore never known in advance.
4.2 - Reporting
Reporting query are well-known query used to build metrics. See Data Analysis - Reporting Query