查询条件为在一段时间内,按小时统计数据库表中某字段的平均值,我写的sql语句如下:
select CONVERT(varchar(13),时间,120) as '时间',AVG(剂量率) as '平均值' from GM数据 group by
CONVERT(varchar(13),时间,120) where 时间 between '2012-3-1 1:03:23' and '2012-5-19 10:47:23';运行时提示错误:
消息 156,级别 15,状态 1,第 2 行
关键字 'where' 附近有语法错误。请问正确的sql语句该如何写,谢谢!
select CONVERT(varchar(13),时间,120) as '时间',AVG(剂量率) as '平均值' from GM数据 group by
CONVERT(varchar(13),时间,120) where 时间 between '2012-3-1 1:03:23' and '2012-5-19 10:47:23';运行时提示错误:
消息 156,级别 15,状态 1,第 2 行
关键字 'where' 附近有语法错误。请问正确的sql语句该如何写,谢谢!
先where 在group by
select CONVERT(varchar(13),时间,120) as '时间',AVG(剂量率) as '平均值' from GM数据
where 时间 between '2012-3-1 1:03:23' and '2012-5-19 10:47:23'
group by
CONVERT(varchar(13),时间,120)
where 时间 between '2012-3-1 1:03:23' and '2012-5-19 10:47:23'
group by CONVERT(varchar(13),时间,120);
这样试试,先where子句,再group by子句。