在oracle中有minus运行符,而sqlserver中没有,而是用except代替,代码如下:
select [id],name from hyc.Serviceman where [id]>10 except select [id],name from hyc.serviceman where [id]>20
在oracle中有minus运行符,而sqlserver中没有,而是用except代替,代码如下:
select [id],name from hyc.Serviceman where [id]>10 except select [id],name from hyc.serviceman where [id]>20