在vb中我想把下面的语句通过字段reportid分组,我用的是ACCSESS数据库的
DataQuery.RecordSource = "select * from paper where papernum>=" & Val(PaperNum(0).Text) & " and papernum<=" & Val(PaperNum(1).Text) & " and paperkind=0 and state=1"我上面的语句是对的我写的分组语句是这样的,就是在上面的语句加了group by
DataQuery.RecordSource = "select reportid,reporttitle from paper where papernum>=" & Val(PaperNum(0).Text) & " and papernum<=" & Val(PaperNum(1).Text) & " and paperkind=0 and state=1 group by reportid"但是什么都查 不出来。是不是我下面的语句不对,还是在vb用group by有别的写法???
我是vb新手
DataQuery.RecordSource = "select * from paper where papernum>=" & Val(PaperNum(0).Text) & " and papernum<=" & Val(PaperNum(1).Text) & " and paperkind=0 and state=1"我上面的语句是对的我写的分组语句是这样的,就是在上面的语句加了group by
DataQuery.RecordSource = "select reportid,reporttitle from paper where papernum>=" & Val(PaperNum(0).Text) & " and papernum<=" & Val(PaperNum(1).Text) & " and paperkind=0 and state=1 group by reportid"但是什么都查 不出来。是不是我下面的语句不对,还是在vb用group by有别的写法???
我是vb新手
DataQuery.RecordSource = "select reportid,reporttitle from paper where ( papernum >= " & Val(PaperNum(0).Text) & " and papernum <= " & Val(PaperNum(1).Text) & " and paperkind=0 and state=1 ) group by reportid"有没有什么报错信息?
试图执行一个合计函数中不包含特定表达示'reporttitle'的查询
比如说以下表s
class
1 79
1 80
1 81
2 80
2 60
...要算1班的平均分:
select class,avg() from s group by class
得到结果就是
class avg()
1 80
2 70
...象楼主的sql,有group by 却不知道统计哪个字段,用group by 有什么用呢?
给你几个个Group BY的示例用法,这几个用法的语法应该没问题,但未必是你希望的统计结果。
1、
select reportid,reporttitle,Count(*) As Num from paper where papernum>=" & Val(PaperNum(0).Text) & " and papernum<=" & Val(PaperNum(1).Text) & " and paperkind=0 and state=1 group by reportid,reporttitle2、
select reportid,reporttitle,Sum(papernum) As Num from paper where papernum>=" & Val(PaperNum(0).Text) & " and papernum<=" & Val(PaperNum(1).Text) & " and paperkind=0 and state=1 group by reportid,reporttitle3、
select reportid,reporttitle,Max(papernum) As Num from paper where papernum>=" & Val(PaperNum(0).Text) & " and papernum<=" & Val(PaperNum(1).Text) & " and paperkind=0 and state=1 group by reportid,reporttitle
所以应该是select reportid,reporttitle,sum(XXX) as xxxsum from table group by reportid,reporttitle