Assingment
Assign #1
Make a total of three retrieval queries with your own retrieval problem definition, by referring to the following. Problem definition and query results will be evaluated. (6 points;2- 2-2)
You first define one problem for each direction, followed by making an answer query statement and showing its returned result.
Directions:
- A query that join three or more tables.
- A query that join two or more tables and generates useful data and information for simple decision making.
- An interesting query that uses outer join (any of full, left or right outer join)
Submission
Direction #1
Direction #2
Direction #3
'데이터베이스' 카테고리의 다른 글
| Shared Lock 과 Exclusive Lock (0) | 2021.12.05 |
|---|---|
| Join 쿼리를 어떻게 최적화할까 (0) | 2021.03.10 |
| 로그인 아이디는 왜 pk로 적절하지 않을까? (0) | 2021.03.04 |
| Narrative to ERD - Individual Assignment #3 (0) | 2020.12.23 |
| Nested Query - Individual Assignment #2 (0) | 2020.12.23 |
