SQL - Query (SELECT)

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

3 - Equal

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

5 - To relational algebra

6 - Documentation / Reference

Data Science
Data Analysis
Data Science
Linear Algebra Mathematics

Powered by ComboStrap