SQL SELECT: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
No edit summary
Line 21: Line 21:


===Multiple Tables===
===Multiple Tables===
 
{{Internal|SQL_Querying_Multiple_Tables#Overview|Querying Multiple Tables}}
Link here. Joining Tables.


==<tt>WHERE</tt>==
==<tt>WHERE</tt>==

Revision as of 21:09, 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

Querying Multiple Tables

WHERE

Filters, conditions, condition evaluation.

GROUP BY ... HAVING

(make sure I understand thoroughly and link)

ORDER BY