sql 多列求和

列相加即可
注意Null不可加，先用ISNULL方法验证，设置默认值

SELECT  ID,
        Name,
        Province,
        City,
        District,
        ISNULL(row1, 0),
        ISNULL(row2, 0),
        ISNULL(row3, 0),
        ISNULL(row4, 0),
        ISNULL(row5, 0) + ISNULL(row6, 0) + ISNULL(row7, 0)
        + ISNULL(row8, 0) AS 'total'
FROM    O WITH(NOLOCK)
posted @ 2017-11-21 17:13  Lulus  阅读(5228)  评论(0)  编辑  收藏  举报