sql 行转列

最新推荐文章于 2024-07-23 15:38:58 发布

wing123123

最新推荐文章于 2024-07-23 15:38:58 发布

阅读量111

点赞数

分类专栏： SQL 文章标签： SQL C C++ C# F#

本文链接：https://blog.csdn.net/wing123123/article/details/83875179

版权

SQL 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

SELECT     sss
FROM         (SELECT     TOP (1) 1 AS Expr1, A AS sss
                       FROM          com_jjxx
                       UNION
                       SELECT     TOP (1) 2 AS Expr1,  B AS aaaa
                       FROM         com_jjxx AS com_jjxx_5
                       UNION
                       SELECT     TOP (1) 3 AS Expr1,  C AS bbb
                       FROM         com_jjxx AS com_jjxx_4
                       UNION
                       SELECT     TOP (1) 4 AS Expr1,  D AS ccc
                       FROM         com_jjxx AS com_jjxx_3
                       UNION
                       SELECT     TOP (1) 5 AS Expr1, E AS ddd
                       FROM         com_jjxx AS com_jjxx_2
                       UNION
                       SELECT     TOP (1) 6 AS Expr1, F  AS eeee
                       FROM         com_jjxx AS com_jjxx_1) AS a

有必要解释一下... 1,2,3,4,5,6, 就是就要显示的内容的一个排序.. A,B,C,D,E,F 就是要显示的内容.当然, com_jjxx 这个表里面要有这些字段. com_jjxx 后面也可以加WHERE 条件...