如何在sql server中计算多列的平均值和排除零

SELECT 
    CASE WHEN column1 = 0 THEN NULL ELSE column1 END AS column1,
    CASE WHEN column2 = 0 THEN NULL ELSE column2 END AS column2,
    CASE WHEN column3 = 0 THEN NULL ELSE column3 END AS column3
FROM your_table;

SELECT 
    (SELECT AVG(column1) FROM (
        SELECT CASE WHEN column1 = 0 THEN NULL ELSE column1 END AS column1
        FROM your_table
    ) AS temp) AS avg_column1,
    (SELECT AVG(column2) FROM (
        SELECT CASE WHEN column2 = 0 THEN NULL ELSE column2 END AS column2
        FROM your_table
    ) AS temp) AS avg_column2,
    (SELECT AVG(column3) FROM (
        SELECT CASE WHEN column3 = 0 THEN NULL ELSE column3 END AS column3
        FROM your_table
    ) AS temp) AS avg_column3;