VAR_SAMP operates differently depending on whether or not there is a GROUP BY clause in the SELECT statement.
| IF the query … | THEN VAR_SAMP is reported for … |
|---|---|
| specifies a GROUP BY clause | each individual group. |
| does not specify a GROUP BY clause | all the rows in the sample. |