Question

asp.net中按价格区间查询的select查询代码怎么写？

价格区间是文本框中输入的。

Answer 1

select * from table where price between 10 and 20

Answer 2

between and

追问

select productname,addtime,price,city,quantity from t_Product where price between '%" + this.TextBox1.Text.Trim() + "%' and '%" + this.TextBox2.Text.Trim() + "%'"这样写对吗？

追答

不要%

Answer 3

oder by