Karteikarten
Week 10 - Advanced SQL
Karten in diesem Stapel (7)
- 1Nested subquerySubquery is independent of outer query and is executed only once
- 2Correlated subquerySubquery is related to query and is evaluated once for each row of outer query
- 3Inline subquery
- 4ViewVirtual table derived from one or more base tables, sometimes used as "Access Control" to the database
- 5Relational set operatorsUNION - combines rows from two or more queries without including duplicate rows
UNION ALL - combines rows from two or INTERSECT - combines rows from two queries, returning only the rows that appear in both sets (alternative to IN)
MINUS - combines rows from two queries, returning only rows that appear in the first set but not second (alternative to NOT IN) - 6Extract and decode
- 7Left/right pad
Informationen
- Beschreibung
- Computer Science (FIT2094: Databases) Karteikarten am Week 10 - Advanced SQL, erstellt von Melina Mackey am 09/11/2020.
- Erstellt von
- Melina Mackey
- Aufrufe
- 0
- Verlauf
-
- Erstellt von Melina Mackey · 19 Okt 2020
- Kopiert von Melina Mackey · 25 Okt 2020
- Kopiert von Melina Mackey · 1 Nov 2020
- Kopiert von Melina Mackey · 6 Nov 2020
- Kopiert von Melina Mackey · 8 Nov 2020
- Kopiert von Melina Mackey · 9 Nov 2020
- Bewertung