
SQL
belldeep
c java perl python shell
Linux
展开
-
SQL : joins
SQL left join , right join , full outer join转载 2017-07-29 07:27:46 · 288 阅读 · 0 评论 -
SQL : 求月平均值 , 求周平均值
## 基金净值:求月平均值select month(date1) as "月份", min(jz) as "月最小值", round(avg(jz),4) as "月平均值", max(jz) as "月最大值"from jjjzwhere dm='660008' and year(date1)='2018'group by month(date1)order by 1;...原创 2018-12-09 12:31:15 · 9391 阅读 · 0 评论