关系模式如下:Product(maker,model,type)PC(model,speed,ram,hd,price)Printer(model,color,type,price)Laptop(model,speed,ram,hd,price)用SQL表达查询所有彩色激光打印机的型号,下面的表达形式正确的是( )。
A、SELECT modelFROM printerWHERE color=”T” and type=“jet”.
B、SELECT modelFROM printerWHERE color=”T” INTERSECTION SELECT modelFROM printerWHERE type=“jet”
C、SELECT modelFROM printerWHERE color=”T” UNION SELECT modelFROM printerWHERE type=“jet
D、SELECT modelFROM printerWHERE color=”T” OR type=“jet
发布时间:2025-04-01 07:52:29