I want to calculate the standard deviation of data that are in multiple
columns. I know how to calculate the STD of 1 column (e.g. X1 of
SELECT STD(X1) FROM table_X;
but I want to calculate now the STD of the union of data of columns
(e.g. X1, X2, ..., X100 of table_X).
Does anyone has any suggestion on how to do that? I hoped something as
SELECT STD(X1,X2,...,X100) FROM table_X existed, but apparently it does
Thanks for your suggestions in advance!