qq_28167007 于 2015.07.16 21:31 提问
- SQL语句子查询问题,求高手指教
-
判断一个值在是否在1-6月份出现过，如果没有，则取这个值。要怎么写。
-
-
oyljerry
2015.07.16 21:36
select x from table where x not exist (select x from table where yuefen in (1,2,3,4,5,6)
-
- CSDNXIAON 2015.07.16 21:33
sql语句子查询大全
SQL技术：sql语句子查询大全
----------------------同志你好，我是CSDN问答机器人小N，奉组织之命为你提供参考答案，编程尚未成功，同志仍需努力！
-
-
strutce
2015.07.16 21:42
select * from table where 值 not in (select 值所对应的字段 from table where time between 1 and 6 没有查到记录就是这个值了
-
-
u012216727
2015.07.16 22:36
select * from table where value not in(select * from table where month in(1,2,3,4,5,6))
-
-
cuiwei1026522829
2015.07.17 00:16
select
x
from table
where x
not exist (select
x
from table
where yuefen
in (1,2,3,4,5,6)
-
- u012401478 2015.07.17 09:34
select x from table where x not exist (select x from table where yuefen in (1,2,3,4,5,6)