价格区间查询语句。。。。。。。。。。。

[flashlove2008]

产品关键字，起始价格，结束价格，

要求查询结果准确无误

[cwmwss]

学习了呵呵

[che2piaopiao]

Between and 

[jiang_jiajia10]

关键字用模糊，价格用精准查询

select * from table where key like  keys% and upprice>=1 and downprice<=2 

[liujiayu10]

between a and b

a和b分别为价格区间的起始和结束就可以了啊，最多就是用cast转换一下格式啊

[kerry030401]

没明白啥意思？between语句？

[flashlove2008]

到底between和第一种在执行上有什么区别

[herty]

between 就好了啦

[koukoujiayi]

select * from table where 关键字= 关键字值
and (起始价格 between 起始价格值1 and 起始价格值2)
and (结束价格 between 结束价格值1 and 结束价格值2)

[kerry030401]

楼上正解，
between 很好用的 很方便了

[lovehongyun]

between and 就行了.

[wonture]

select * from table where key like  %keys% and upprice between  1 and 2

[kingya2008]

两种方法没什么区别，一样的，看你用哪种咯

[readfuture]

between and 好一点吧
select * from table where key like keys% and upprice>=1 and downprice<=2

[readfuture]

[Quote=引用 11 楼 readfuture 的回复:]
between and 好一点吧
select * from table where key like keys% between upprice>=1 and downprice <=2
[/Quote]
刚才错了

[readfuture]

select * from table where key like keys% between upprice and downprice
罪过，又误导别人了

[CutBug]

between and 还要快点

[Robin]

between and