ex2-7.sql

来自「数据库系统练习答案」· SQL 代码 · 共 9 行

SQL
9
字号
select *
from "member"
where "memno" IN
	(select "memno"
	from "member"
	EXCEPT 
	(select  "borrowermemno" 
	from "book"
	where "borrowermemno" IS NOT NULL)) 

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?