计算每行的平均值,然后计算每列的平均值

尝试交叉应用

SELECT 
    AVG(t2.Average)
FROM
    Table t1
    CROSS APPLY (
        SELECT Average = AVG(Value) 
        FROM (VALUES (Col1), (Col2), (Col3), (Col4)) B1(Value)
    ) t2

结果是 65.221666

cross apply 和 grouping sets :

select t.id, avg(row_avg)
from t cross apply
     (select avg(col) as row_avg
      from (values (col1), (col2), (col3), (col4)) v(col)
     ) s
group by grouping sets ( (id), () );

以上假设您有一个唯一的id来标识每一行。如果没有,那么你需要像 union all

with s as (
      select t.*, s.row_avg
      from t cross apply
           (select avg(col) as row_avg
            from (values (col1), (col2), (col3), (col4)) v(col)
           ) s
     )
select s.row_avg
from s
union all
select avg(s.row_avg)
from s;

所以您需要每行和每列的平均值?我将做两个单独的计算,一个用于行,另一个用于列。通读表格并找出每行的平均值,将列值存储在临时列表格或列表中。