作用:返回组中数据窗口的第一个值
语法:select first_value(栏位1) over(PARTITION BY 栏位2 [,栏位3 order by 栏位4 ASC,栏位5 DESC]) from 表名
范例:select distinct first_value(employee_name) over(PARTITION BY dept_id order by input_date desc)
from Employee
作用:返回组中数据窗口的第一个值
语法:select first_value(栏位1) over(PARTITION BY 栏位2 [,栏位3 order by 栏位4 ASC,栏位5 DESC]) from 表名
范例:select distinct first_value(employee_name) over(PARTITION BY dept_id order by input_date desc)
from Employee