Please enable JavaScript.
Coggle requires JavaScript to display documents.
SQL, DDL, DML, SELECT, Integrity Constraints, JOIN - Coggle Diagram
-
-
-
SELECT
-
-
-
Subqueries
A subselect can be used in WHERE and HAVING clauses of an outer SELECT, where it is called a subquery or nested query
Integrity Constraints
Entity Integrity
PK of a table must contain a unique, non-null value for each row
Referential Integrity
if FK contains a value, that value
must refer to existing row in parent table
-