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 + -
显示快捷键?