Let say I have a Table in SQL server with 10 columns with header Col-1, Col-2, ... Col-10
. Now I want to write an SQL query which will first calculate the Column-sums for all 10 columns individually - thereby a row of length 10 will be generated, and then calculate the median of the values of that generated row.
To add further detail, let say I have below table. What I need SQL is to calculate the Median of Col-sum values as in below illustration.
Col - 1 Col - 2 Col - 3 Col - 4 Col - 5 Col - 6 Col - 7 Col - 8 Col - 9 Col - 10
0.4763 0.9746 0.5082 0.8707 0.3608 0.6984 0.9326 0.9983 0.1441 0.6882
0.9396 0.9358 0.6548 0.8046 0.3274 0.3072 0.1275 0.8273 0.9785 0.9618
0.6656 0.7000 0.1664 0.0341 0.9804 0.4973 0.2023 0.4619 0.9759 0.0456
0.9707 0.3495 0.8282 0.6389 0.8845 0.8833 0.8424 0.6087 0.4165 0.6986
0.5992 0.8121 0.0324 0.9134 0.9613 0.6163 0.1110 0.8911 0.7429 0.4397
0.1069 0.6702 0.6478 0.9055 0.3594 0.0060 0.0556 0.4216 0.0578 0.2796
Col-sum 3.7583 4.4421 2.8378 4.1672 3.8737 3.0085 2.2714 4.2088 3.3157 3.1135
**Median 3.537024951**
Any pointer how to implement such in SQL will be highly appreciated. Thanks,
See Question&Answers more detail:os