需求:传入订单号返回不存在得订单号列表
思路:构建一个订单号得视图 在通过extis判断是否存在
重点:
select order_no from (select '传入值A' order_no union
select '传入值B' order_no union select '传入值A' order_no ......) a where
exits (Select 1 from order b where a.order_no=b.order_no)
需求:传入订单号返回不存在得订单号列表
思路:构建一个订单号得视图 在通过extis判断是否存在
重点:
select order_no from (select '传入值A' order_no union
select '传入值B' order_no union select '传入值A' order_no ......) a where
exits (Select 1 from order b where a.order_no=b.order_no)