高考问答田晓龙和李丹妮现状:vb select查询问题
来源：百度文库 编辑：高考问答 时间：2024/05/06 03:06:34
我想在查询语句中在进行运算，怎么实现呢？
比如Dim date0 As String
Dim date1 As String
Dim date2 As String
Dim date3 As String
date0 = DTP1.Value & " 00:00:00"
date1 = DTP1.Value & " 08:00:00"
date2 = DTP1.Value & " 16:00:00"
date3 = DTP1.Value & " 23:59:59"
If Combo1.Text = "白班" Then
Adodc1.RecordSource = "select * from 数据记录 where 时间 >= CDate('" & date1 & "') and 时间 <= CDate('" & date2 & "')"
Adodc1.Refresh
End If
上段语句中我想再加个运算语句，怎么加呢？？
select * from 数据记录 where sum(字段3) as 字段4
我加了怎么不可以呢？
比如Dim date0 As String
Dim date1 As String
Dim date2 As String
Dim date3 As String
date0 = DTP1.Value & " 00:00:00"
date1 = DTP1.Value & " 08:00:00"
date2 = DTP1.Value & " 16:00:00"
date3 = DTP1.Value & " 23:59:59"
If Combo1.Text = "白班" Then
Adodc1.RecordSource = "select * from 数据记录 where 时间 >= CDate('" & date1 & "') and 时间 <= CDate('" & date2 & "')"
Adodc1.Refresh
End If
上段语句中我想再加个运算语句，怎么加呢？？
select * from 数据记录 where sum(字段3) as 字段4
我加了怎么不可以呢？
Sql = "select SUM([FILED3]) as FILED4 from 数据记录 where 时间 >= CDate('" & date1 & "') and 时间 <= CDate('" & date2 & "')"
或
Sql = "select FILED1,SUM([FILED3]) as FILED4 from 数据记录 where 时间 >= CDate('" & date1 & "') and 时间 <= CDate('" & date2 & "')" & "GROUP BY FILED1
或
Sql = "select FILED2,SUM([FILED3]) as FILED4 from 数据记录 where 时间 >= CDate('" & date1 & "') and 时间 <= CDate('" & date2 & "')" & "GROUP BY FILED2
或
Sql = "select FILED1,FILED2,SUM([FILED3]) as FILED4 from 数据记录 where 时间 >= CDate('" & date1 & "') and 时间 <= CDate('" & date2 & "')" & "GROUP BY FILED1,FILED2
select 字段1,字段2,sum(字段3) as 字段4 from 数据记录 Group By 字段1,字段2
sum、count等都是聚合函数，需要添加Group By