SQL SELECT: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 44: Line 44:


==<tt>GROUP BY ... HAVING</tt>==
==<tt>GROUP BY ... HAVING</tt>==
 
{{Internal|SQL_GROUP_BY#Overview|<tt>GROUP BY ... HAVING</tt>}}
(make sure I understand thoroughly and link)


==<tt>ORDER BY</tt>==
==<tt>ORDER BY</tt>==


=Subqueries=
=Subqueries=

Revision as of 23:14, 22 May 2024

Internal

Overview

A query consists in at least one (SELECT) and at most six categories of clauses:

SELECT [...] FROM [...] WHERE [...] GROUP BY [...] HAVING [...] ORDER BY [...]

The following query:

SELECT;

is valid, it returns one empty row.

Upon execution, an SQL query returns a result set.


Select all (possibly across multiple tables) then filter and discard with where.

Example

SELECT id, name FROM person WHERE id = 1;

Clauses

SELECT

FROM

FROM permanent|derived|temporary|virtual(view)

Table alias.

Querying Multiple Tables

Querying Multiple Tables

WHERE

The WHERE Clause

GROUP BY ... HAVING

GROUP BY ... HAVING

ORDER BY

Subqueries