part3.txt
来自「ssd7 ex1 Design the following two table」· 文本 代码 · 共 33 行
TXT
33 行
1.In 1.2.2 Relational Operations, there is an example of the set's different operation: the result of r - s is provided for you. Provide result of the set's different operation s - r.
Table s-r
-------------------------
- D E F -
- b g a -
-------------------------
2.In the class notes, the following UNION example was discussed. Give a prosaic description of the results that will be retrieved by replacing UNION with EXCEPT in following query:
( SELECT MemNo
FROM MEMBER, BOOK
WHERE MemNo = BorrowerMemNo AND
CallNumber = 'QA76.9.D26C66'
)
EXCEPT
( SELECT MemNo
FROM MEMBER, BOOK
WHERE MemNo = BorrowerMemNo AND
CallNumber = 'QA76.9.D7E53'
);
Description:Return a list of member numbers of all members currently borrowing the book which has call number QA76.9.D26C66 not QA76.9.D7E53.
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?