1. 应用场景
- 在用OpenSQL取数时;既要看到每个日期占据头等舱的座位数量的数据,也要取得所有日期占据头等舱的座位数量的平均值
2. 代码
- SQL Window Expression 使用关键词 OVER
- PARTITION BY 相当于OpenSQL中的Group By
SELECT carrid, connid, fldate, seatsocc_f, SUM( seatsocc_f ) OVER( PARTITION BY carrid, connid ) AS sum_seatsocc_f, COUNT( seatsocc_f ) OVER( PARTITION BY carrid, connid ) AS count_seatsocc_f, MIN(