I have a question about how SQL assigns a value to a variable if the Select statement returns multiple results.
For example if the following Select statement returns 5 rows, which one is assigned to the variable.

```
declare @i int
SELECT @i = age
  FROM student

```