雷達圖分析三國超一流謀士、統帥數據，獻給廣大的三國愛好者們，希望喜歡三國的朋友一起討論，加深對傳奇三國時代的了解

建立數據環境：

-- 抽取三國超一流謀士TOP 10數據DECLARE @t1 TABLE    (      [姓名] NVARCHAR(255) ,      [統率] FLOAT ,      [武力] FLOAT ,      [智力] FLOAT ,      [政治] FLOAT ,      [魅力] FLOAT    )            INSERT  INTO @t1        SELECT TOP 10                [姓名] ,                [統率] ,                [武力] ,                [智力] ,                [政治] ,                [魅力]        FROM    FactSanguo11        WHERE   ( [智力] + [政治] > 160 )                AND ( [智力] >= 90 )                AND 姓名 <> N'曹操'        ORDER BY [智力] + [政治] DESCSELECT  *FROM    @t1 -- 列轉行處理SELECT  [姓名] ,        [指標項] = attribute ,        [指標值] = valueFROM    @t1 UNPIVOT  ( value FOR attribute IN ( [統率], [武力], [智力], [政治], [魅力] ) ) AS UPV

執行結果：

-- 抽取三國超一流統帥TOP 10數據DECLARE @t2 TABLE    (      [姓名] NVARCHAR(255) ,      [統率] FLOAT ,      [武力] FLOAT ,      [智力] FLOAT ,      [政治] FLOAT ,      [魅力] FLOAT    )    INSERT  INTO @t2        SELECT TOP 10                [姓名] ,                [統率] ,                [武力] ,                [智力] ,                [政治] ,                [魅力]        FROM    FactSanguo11        WHERE   [統率] + [武力] > 150        ORDER BY [統率] + [武力] DESCSELECT  *FROM    @t2 -- 列轉行處理SELECT  [姓名] ,        [指標項] = attribute ,        [指標值] = valueFROM    @t2 UNPIVOT  ( value FOR attribute IN ( [統率], [武力], [智力], [政治], [魅力] ) ) AS UPV

執行結果：三國超一流謀士、統帥配圖：雷達圖分析三國超一流謀士、統帥數據（最終客戶端效果）：