WINDOW FUNCTION LAST_VALUE

description

LAST_VALUE() 返回窗口范围内的最后一个值。与 FIRST_VALUE() 相反。

1. LAST_VALUE(expr) OVER(partition_by_clause order_by_clause [window_clause])

example

使用FIRST_VALUE()举例中的数据：

1. select country, name,
2. last_value(greeting)
3. over (partition by country order by name, greeting) as greeting
4. from mail_merge;

6. | country | name    | greeting     |
7. |---------|---------|--------------|
8. | Germany | Boris   | Guten morgen |
9. | Germany | Michael | Guten morgen |
10. | Sweden  | Bjorn   | Tja          |
11. | Sweden  | Mats    | Tja          |
12. | USA     | John    | Hello        |
13. | USA     | Pete    | Hello        |

keywords

1. WINDOW,FUNCTION,LAST_VALUE