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. |