多个窗口函数应用于同一分区
多个窗口功能可以应用到同一个分区吗?(如果我用的词不正确,请纠正我。例如你可以
SELECT name,first_value() over (partition by name order by date) from table1但是有没有办法做类似的事情:
SELECT name,(first_value() as f,last_value() as l (partition by name order by date)) from table1在同一个窗口应用两个函数?
参考:http :
//postgresql.ro/docs/8.4/static/tutorial-
window.html
解决方案:
你不仅可以使用每个选择的窗口吗?
就像是
SELECTname, first_value() OVER (partition by name order by date) as f, last_value() OVER (partition by name order by date) as l from table1你也可以从你的参考中做到这一点
SELECT sum(salary) OVER w,avg(salary) OVER wFROM empsalaryWINDOW w AS (PARTITION BY depname ORDER BY salary DESC)
页:
[1]