Question

ASP 查询条件查询一直写不对

这个查询语句 怎么写都不对 ， 帮忙看看怎么个情况..
-----------------------
sql="select top 12 * from db_produce_show where db_rice > '5000' and db_rice< '10000' order by db_id order by db_id Asc"
------------------------
要找5000~10000的数据

Answer 1

sql="select top 12 * from db_produce_show where db_rice > '5000' and db_rice< '10000' order by db_id Asc"
你这样试试

就买我商城、电脑配件批发商城技术员小李为您解答

Answer 2

sql="select top 12 * from db_produce_show where db_rice > '5000' and db_rice< '10000' order by db_id order by db_id Asc"

有两个问题，db_rice 是什么数据类型，如果不是字符串这一类的不用加单引号。后面的排序，order by，只要一个order by就行了，你写两次干嘛
这样改试试
sql="select top 12 * from db_produce_show where db_rice > 5000 and db_rice< 10000 order by db_id Asc"

Answer 3

sql="select top 12 * from db_produce_show where db_rice >'5000 and db_rice< 10000 order by db_id order by db_id Asc"