sql条件查询
来源:百度知道 编辑:UC知道 时间:2024/09/19 16:46:26
select * from table where set_svcname
not in('600003','600004','600009','600010','600013','600323')
如果不采用not in应该怎么写?
not in('600003','600004','600009','600010','600013','600323')
如果不采用not in应该怎么写?
可以试试 not exists
select * from table where set_svcname='你要查询的'
把这几个值创建一个临时表,然后用not exists来查询不知道如何?
如果你想提高查询效率的话,最好还是看执行计划
select * from table t1 left join
(select set_svcname from table where set_svcname
in('600003','600004','600009','600010','600013','600323')) t2
on t1.set_svcname = t2.set_svcname
where t2.set_svcname is null
这就是最简单写法了.
你的已经是最简单的了
你可以试试下面这个效率
select * from table where set_svcname
<> '600003' and
set_svcname
<>'600004' and
set_svcname
<>'600009' and
set_svcname
<>'600010' and
set_svcname
<>'600013' and
set_svcname
<>'600323'