摘要: -- 数据透视-- PIVOT: 行转列 SELECT * FROM ( SELECT N'张三' AS 姓名, N'语文' AS 课程,70 AS 分数 UNION SELECT N'张三' AS 姓名, N'数学' AS 课程,90 AS 分数 UNION... 阅读全文
posted @ 2014-08-29 23:18 陈意 阅读(184) 评论(0) 推荐(0) 编辑