SQL函数

四舍五入取整 round()
向下取整 FLOOR()
向上取整 CEIL()
拼接 concat()

sum over partition by order by 的用法

1. select v1,v2,sum(v2) over(partition by v1 order by v2) as sum from wmg_test; --先分组，组内在进行相加操作