多个窗口功能可以应用到同一个分区吗?(如果我用的词不正确,请纠正我。 $ _, {: J$ f Y, p! N例如你可以 0 h& [# Z# W4 hSELECT name,first_value() over (partition by name order by date) from table1但是有没有办法做类似的事情: & P% V; \6 G8 I7 M! n _7 W% Y" [, [SELECT name,(first_value() as f,last_value() as l (partition by name order by date)) from table1在同一个窗口应用两个函数?4 y C5 P2 ~; U# K+ E7 G/ t
参考:http : - M1 ^! f4 w* N0 |//postgresql.ro/docs/8.4/static/tutorial-5 ~, @! r% r6 z; i
window.html& m4 M/ k0 P( w/ k; x, {; ]
3 \; H! Q# ?' ?( [ 解决方案: 7 b n7 A; B* k6 B
你不仅可以使用每个选择的窗口吗? ; |5 q, T# Q n! N* n- j/ u0 g/ A就像是 ; B; h- g: Z# ~# X# V i1 P* }1 iSELECT name, first_value() OVER (partition by name order by date) as f, last_value() OVER (partition by name order by date) as l from table1你也可以从你的参考中做到这一点 - _6 t6 ^, f) W, zSELECT sum(salary) OVER w,avg(salary) OVER wFROM empsalaryWINDOW w AS (PARTITION BY depname ORDER BY salary DESC)