Flashcards
Week 10 - Advanced SQL
Cards in this deck (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
Information
- Description
- Computer Science (FIT2094: Databases) Flashcards on Week 10 - Advanced SQL, created by Melina Mackey on 09/11/2020.
- Created by
- Melina Mackey
- Views
- 0
- History
-
- Created by Melina Mackey · Oct 19, 2020
- Copied by Melina Mackey · Oct 25, 2020
- Copied by Melina Mackey · Nov 1, 2020
- Copied by Melina Mackey · Nov 6, 2020
- Copied by Melina Mackey · Nov 8, 2020
- Copied by Melina Mackey · Nov 9, 2020
- Rating