SQL : 求月平均值，求周平均值

belldeep

于 2018-12-09 12:31:15 发布

阅读量9.4k

点赞数

CC 4.0 BY-SA版权

分类专栏： SQL

本文链接：https://blog.youkuaiyun.com/belldeep/article/details/84925436

SQL 专栏收录该内容

2 篇文章

订阅专栏

本文提供了针对特定基金（代码660008）在2018年的月度和周度净值统计，包括月平均值、周平均值、最小值和最大值的计算方法。通过SQL查询展示了如何从数据库中提取并分析这些数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

## 基金净值：求月平均值

select month(date1) as "月份"
, min(jz) as "月最小值"
, round(avg(jz),4) as "月平均值"
, max(jz) as "月最大值"
from jjjz
where dm='660008' and year(date1)='2018'
group by month(date1)
order by 1
;

## 基金净值：求周平均值

select week(date1) as "周数"
, min(jz) as "周最小值"
, round(avg(jz),4) as "周平均值"
, max(jz) as "周最大值"
from jjjz
where dm='660008' and year(date1)='2018'
group by week(date1)
order by 1
;

python 计算平均数

# 计算平均数
def average(alist):
    nsum = 0.0
    for i in range(len(alist)):
        nsum += alist[i]
    return round(nsum / len(alist), 4)

h2database:

select WEEK(PARSEDATETIME(date1,'yyyyMMdd')) as weeks
, min(jz) as "周最小值"
, round(avg(jz),4) as "周平均值"
, max(jz) as "周最大值"
from jjjz
where dm='660008' and year(date1)='2018'
group by WEEK(PARSEDATETIME(date1,'yyyyMMdd'))
order by 1
;