

# FIRST\$1VALUE
<a name="sql-reference-first-value"></a>

```
FIRST_VALUE( <value-expression>) <null treatment> OVER <window-specification>
```

FIRST\$1VALUE returns the evaluation of the <value expression> from the first row that qualifies for the aggregate. FIRST\$1VALUE requires the OVER clause, and is considered an [Analytic Functions](sql-reference-analytic-functions.md). FIRST\$1VALUE has a null treatment option defined in the following table.


| Null treatment option | Effect | 
| --- | --- | 
|  FIRST\$1VALUE(x) IGNORE NULLS OVER <window-specification>  |  Returns first non null value of x in <window-specification>  | 
|  FIRST\$1VALUE(x) RESPECT NULLS OVER <window-specification>  |  Returns first value, including null of x in <window-specification>  | 
|  FIRST\$1VALUE(x) OVER <window-specification>  |  Returns first value, including null of x in <window-specification>  | 