where条件中出现between and 子句就不能用其他条件了吗 例如select money from tablewhere money between 100 and 1000and id>1101 //如果加这样的条件就报错 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 -----try-----select money from tablewhere id>1101 and money between 100 and 1000 你的id是不是字符型的?這樣試試select [money] from tablewhere [money] between 100 and 1000and id>'1101' 不會吧?給一些關鍵字加[],給條件加()select [money] from [table]where ([money] between 100 and 1000)and ([id]>1101) select [money] from tablewhere ([money] between 100 and 1000)and [id]>1101 急,在线等!!!一个数据存储过程的问题 触发器的问题 问一个语句怎么写! 两个表如何删除数据 [SQL - ADO]连接到数据库当网路断开等情况时,如何监控连接中断 如何用SQL语句获得一个表中某一记录中某一字段的值??? 已知表名,如何获取该表的依赖表? vc6使用odbc api如何取得存储过程的返回值?(在线等!)搜遍搜索引擎未果,期待中...... 请教一条SQL查询语句。 求SQL select @e=@@error怎么没有了?求救 ==帮忙看个Sql,十万火急,拜托了===
where id>1101 and money between 100 and 1000
這樣試試select [money] from table
where [money] between 100 and 1000
and id>'1101'
select [money] from [table]
where ([money] between 100 and 1000)
and ([id]>1101)
where ([money] between 100 and 1000)
and [id]>1101