一个ACCESS查询的问题,解决了送150分! select * from problem where (date<'2002-08-01' or date>'2002-08-01') and id<>"zh16,zh18,zh20,zh33" 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 date是日期型的吗?如果是这样写: select * from problem where (date<#2002-08-01#) or (date>#2002-08-01# and id not in ("zh16","zh18","zh20","zh33") 错了点,最后少了个括号: select * from problem where (date<#2002-08-01#) or (date>#2002-08-01# and id not in ("zh16","zh18","zh20","zh33")) I have give u the answer athttp://expert.csdn.net/Expert/topic/1134/1134270.xml?temp=.6289026not right? select * from problem where date<>'2002-08-01' and id in (zh16,zh18,zh20,zh33) In msdn,there are a article give 'not in' and 'instr' to resolve the problem like this ~~ button sister,nice to meet u 谢谢各位大哥,icevi(按钮工厂)大哥的回答给我解决了问题,真的非常感谢,你可以留个邮箱给我吗? ~~ Button sister! Remember it :) 请教一个sql语句的写法 这个值是如何计算的,|符号啥意思 查询的速度问题 请问 这条SQL语句怎么写啊 求sql按月列出每月注册用户的数量 急~关于SQL连结的伺服器如何增加一个提供者 informix 如何每间隔一段时间查询数据库数据? sq自定义函数 必须变量 瞧一瞧,看一看啊!!!急需帮助!!! oracle书籍下载地址 Win2k+sql 2000,在存储过程里能够实现修改本机的administrator密码吗? 高手,请看这个存储过程哪有错,老是通不过,
select * from problem where (date<#2002-08-01#) or (date>#2002-08-01# and id not in ("zh16","zh18","zh20","zh33")
select * from problem where (date<#2002-08-01#) or (date>#2002-08-01# and id not in ("zh16","zh18","zh20","zh33"))
http://expert.csdn.net/Expert/topic/1134/1134270.xml?temp=.6289026
not right?
select * from problem where date<>'2002-08-01' and id in (zh16,zh18,zh20,zh33)