SQL SELECT: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 8: Line 8:
  SELECT FROM WHERE GROUP BY HAVING ORDER BY  
  SELECT FROM WHERE GROUP BY HAVING ORDER BY  
</font>
</font>
Select all (possibly across multiple tables) then filter and discard with where.
=Clauses=
==<tt>FROM</tt>=
<font>
FROM permanent|derived|temporary|virtual(view)
</font>
Table alias.
===Multiple Tables===
Link here. Joining Tables.
==<tt>WHERE</tt>=
Filters, conditions, condition evaluation.
==<tt>GROUP BY ... HAVING</tt>==
(make sure I understand thoroughly and link)
==<tt>ORDER BY</tt>==

Revision as of 21:07, 22 May 2024

Internal

Overview

Query execution. SQL optimizer. Subqueries.

SELECT FROM WHERE GROUP BY HAVING ORDER BY 

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

Clauses

=FROM

FROM permanent|derived|temporary|virtual(view)

Table alias.

Multiple Tables

Link here. Joining Tables.

=WHERE

Filters, conditions, condition evaluation.

GROUP BY ... HAVING

(make sure I understand thoroughly and link)

ORDER BY