没有between关键字,用to select case i case 1 to 10: case else: end select
select 列名 from 表名 where 列 between A and B
有。 select * from table_name where 字段1 between 100 and 500
呵呵,明明是说的Sql语句,竟然有人把这个问题和Select Case语句联系在一起了。
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
关于这一点,建议参考数据库相关书籍,如《数据库系统概论》等(萨思宣编). 那里面讲得很清楚,就象上面那位老兄所说的: Select * From TableName Where Condition(如:Between A And B) 搞定!
select 中是有between的,其实用and 不是一样吗? select id from table where id between a and b select id from table wher id>a and id<b
有, 主要是指两者之间的值 select * from tabel where 字段1 [条件] between 字段2 [条件]
select case i
case 1 to 10:
case else:
end select
select * from table_name where 字段1 between 100 and 500
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
那里面讲得很清楚,就象上面那位老兄所说的:
Select *
From TableName
Where Condition(如:Between A And B)
搞定!
select id from table where id between a and b
select id from table wher id>a and id<b
主要是指两者之间的值
select * from tabel where 字段1 [条件] between 字段2 [条件]