Fichas
Week 10 - Advanced SQL
Fichas del 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
Información
- Descripción
- (FIT2094: Databases) Computer Science Fichas sobre Week 10 - Advanced SQL, creado por Melina Mackey el 09/11/2020.
- Creado por
- Melina Mackey
- Visitas
- 0
- Historial
-
- Creado por Melina Mackey · 19 oct 2020
- Copiado por Melina Mackey · 25 oct 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
- Valoración