Flashcards
Week 10 - Advanced SQL
Flashcards do conjunto (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
Informações
- Descrição
- Computer Science (FIT2094: Databases) FlashCards sobre Week 10 - Advanced SQL, criado por Melina Mackey em 09-11-2020.
- Criado por
- Melina Mackey
- Visualizações
- 0
- Histórico
-
- Criado por Melina Mackey · 19 out 2020
- Copiado por Melina Mackey · 25 out 2020
- Copiado por Melina Mackey · 1 nov 2020
- Copiado por Melina Mackey · 6 nov 2020
- Copiado por Melina Mackey · 8 nov 2020
- Copiado por Melina Mackey · 9 nov 2020
- Avaliação