多个窗口功能可以应用到同一个分区吗？(如果我用的词不正确，请纠正我。 ) K3 H7 e0 q; K5 p; O例如你可以 4 v$ @' R/ N* U) X8 f! T2 o' xSELECT name,first_value() over (partition by name order by date) from table1但是有没有办法做类似的事情:$ M6 u9 h- t" ^1 h
SELECT name,(first_value() as f,last_value() as l (partition by name order by date)) from table1在同一个窗口应用两个函数？ 9 f8 I3 m- u, ?4 w9 ?6 T. q' C* R参考：http :) n4 D( E5 T) y; l D7 k x5 P
//postgresql.ro/docs/8.4/static/tutorial-! r) B" O( z ]- v
window.html4 }0 } p9 E9 g* h
- }5 u& d, X: O解决方案: 3 ]4 J s4 E$ I0 {# p4 G
你不仅可以使用每个选择的窗口吗？ & l) E4 l$ O% I& l: |1 @就像是3 R$ a, |% W& ?6 R9 t2 I! N! l8 o
SELECT 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 V a9 c3 O. C% FSELECT sum(salary) OVER w,avg(salary) OVER wFROM empsalaryWINDOW w AS (PARTITION BY depname ORDER BY salary DESC)
技术问答
507 人阅读
|
0 人回复
|
2023-09-14
