请教分析函数first_value与min,last_value与max
select a.zhh,a.rq,a.zdl,
first_value(zdl)over(partition by a.rq order by zhh ) first_value,
min(zdl)over(partition by a.rq order by zhh ) min,
last_value(zdl)over(partition by a.rq order by zhh ) last_value,
max(zdl)over(partition by a.rq order by zhh ) max
from R_JLDDL a where zdl<>0
and to_char(rq,'yyyymmdd')='20100819' order by rq,zhh
) t order by rq
结果:
ZHH RQ ZDL FIRST_VALUE MIN LAST_VALUE MAX
1 0150164842 2010/8/19 0.31 0.31 0.31 1983.2 1983.2
2 0150164842 2010/8/19 0.31 0.31 0.31 1983.2 1983.2
3 0150164842 2010/8/19 0.53 0.31 0.31 1983.2 1983.2
4 0150164842 2010/8/19 0.53 0.31 0.31 1983.2 1983.2
5 0150164842 2010/8/19 4.99 0.31 0.31 1983.2 1983.2
6 0150164842 2010/8/19 8.39 0.31 0.31 1983.2 1983.2
7 0150164842 2010/8/19 770.50 0.31 0.31 1983.2 1983.2
8 0150164842 2010/8/19 1983.20 0.31 0.31 1983.2 1983.2
9 0400009119 2010/8/19 0.04 0.31 0.04 1730.77 1983.2
10 0400009119 2010/8/19 0.05 0.31 0.04 1730.77 1983.2
11 0400009119 2010/8/19 576.77 0.31 0.04 1730.77 1983.2
12 0400009119 2010/8/19 576.81 0.31 0.04 1730.77 1983.2
13 0400009119 2010/8/19 756.98 0.31 0.04 1730.77 1983.2
14 0400009119 2010/8/19 757.03 0.31 0.04 1730.77 1983.2
15 0400009119 2010/8/19 1315.61 0.31 0.04 1730.77 1983.2
16 0400009119 2010/8/19 1730.77 0.31 0.04 1730.77 1983.2
我并没有对字段zhh限制,为什么first_value与last_value都会在字段rq下,又按照字段zhh来查找最前一条和最后一条记录?