select语句是否有between关键字？

[airflight]

我在程序里需要用到介于两个值之间的查询，请问select语句是否有between关键字，如果没有应该如何实现

[normandj]

有

[chinareny]

有!

[288794]

使用
select case k
case 1

case 2 to 8 '就是这样了(between)

case else

endselect

[BigRichBigNoble]

没有between关键字,用to
select case i
case 1 to 10:
case else:
end select

[chinareny]

select 列名 from 表名 where 列 between A and B

[ql_mf]

有。
select * from table_name where 字段1 between 100 and 500

[ql_mf]

呵呵，明明是说的Sql语句，竟然有人把这个问题和Select Case语句联系在一起了。

[footballboy]

Private Sub Command1_Click()
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
cnn.Open "Provider=Microsoft.jet.OLEDB.4.0;Data Source=c:\temp\temp.mdb"
rs.Open "select * from 成绩 where score between 60 and 75", cnn, adOpenDynamic, adLockOptimistic
Set MSHFlexGrid1.DataSource = rs
End Sub

[sunbird2002]

关于这一点，建议参考数据库相关书籍，如《数据库系统概论》等（萨思宣编）.
那里面讲得很清楚，就象上面那位老兄所说的：
Select *
From TableName
Where Condition(如:Between A And B)
搞定！

[little_ice]

select 中是有between的，其实用and 不是一样吗？
select id from table where id between a and b
select id from table wher id>a and id<b

[ccbl]

有,
主要是指两者之间的值
select * from tabel where 字段1 [条件] between 字段2 [条件]

[qhzxcz]

有,little_ice(小冰块)的方法也对

[shuchang0626]

有

[xlfhylove]

select * from table where 字段　between 起始值　and 终止值