SQL语法集锦一：SQL语句实现表的横向聚合

/*  
  作    者：<Rising_Sun>
  创建日期：<2012-9-29>
  功    能：<实现表横向聚合>
*/
DECLARE @t TABLE(C1 int,C2 int,C3 int,C4 int,C5 int)
INSERT INTO @t VALUES(1,2,6,3,4)
INSERT INTO @t VALUES(2,2,3,4,5)
INSERT INTO @t VALUES(0,3,6,2,8)

--查询
SELECT *,
    [min] = (
        SELECT MIN(v) FROM(
            SELECT v=A.C1 UNION SELECT v=A.C2 UNION SELECT v=A.C3 UNION SELECT v=A.C4 UNION SELECT v=A.C5
        )B),
    [max] = (
        SELECT MAX(v) FROM(
            SELECT v=A.C1 UNION SELECT v=A.C2 UNION SELECT v=A.C3 UNION SELECT v=A.C4 UNION SELECT v=A.C5
        )B),
    [count>=5] = (
        SELECT COUNT(*) FROM(
            SELECT v=A.C1 UNION SELECT v=A.C2 UNION SELECT v=A.C3 UNION SELECT v=A.C4 UNION SELECT v=A.C5
        )B WHERE v>=5)
FROM @t A