WINDOW FUNCTION MIN
Description
This method is used to calculate the minimum value within the window.
MAX([DISTINCT | ALL] expression) [OVER (analytic_clause)]Example
Calculate the minimum value from the first row to the row after the current row
select x, property,
min(x) over
(
order by property, x desc
rows between unbounded preceding and 1 following
) as 'local minimum'
from int_t where property in ('prime','square');
| x | property | local minimum |
|---|----------|---------------|
| 7 | prime | 5 |
| 5 | prime | 3 |
| 3 | prime | 2 |
| 2 | prime | 2 |
| 9 | square | 2 |
| 4 | square | 1 |
| 1 | square | 1 |Keywords
WINDOW,FUNCTION,MIN