Question

asp 查询数据库语句

我想知道的是如果我是ACCESS的数据库，我想读A.mdb中A表中的HOMO大于等于300而小于等于450的全部数据，同是满足SPEED大于等于12且小于等于15。5如何查询！谢谢急！

Answer 1

<%
set conn=server.createobject("adodb.connection")
conn.open"driver={microsoft access driver (*.mdb)};dbq="&server.mappath("您数据库的相对路径")
'以上是连接数据库
set rs=server.createobject("adodb.recordset")'创建记录集
rs.open"select * from A where (homo>300 and homo<450) and (speed>=12 and speed<=15.5)",conn,1,1
'打开A表 查询
if not rs.eof
do while not rs.eof'循环体开始
response.write rs(0)'输出第一个字段
rs.movenext
loop
end if
rs.close '关闭记录集
%>

好好测试 ```

Answer 2

select * from a where HOMO>=300 and HOMO<=450 and Speed>=12 AND Speed<=15.5

Answer 3

select * from a where HOMO>=300 and HOMO<=450 and Speed>=12 AND Speed<=15.5

Answer 4

select * from A where HOMO>=300 and HOMO<=450 and SPEED>=12 and SPEED<=15.5

Answer 5

select * from a where (homo between 300 and 450) and (speed between 12 and 15)