新人小问题求解
刚刚学数据库,有个地方需要用到except 如下:
select distinct maker
from product
where type = 'laptop'
EXCEPT
select distinct maker
from product
where type = 'pc' or type = 'printer';
但是每次运行是弹出 ORA-00933 sql命令未正确结束 ,这是为什么??
------解决方案--------------------EXCEPT 是SQL SERVER 用法
ORACLE 用 MINUS
select distinct maker
from product
where type = 'laptop'
MINUS
select distinct maker
from product
where type = 'pc' or type = 'printer';