在SQL查询中需要帮助..

本文介绍了在SQL查询中需要帮助..的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

先生，我有一张桌子，其中有数据如下： - [RNo。] [SNo。] [CID] [SID] [StuID ] [A-307] [1] [1495] [1] [1727] [A-307] [2] [1495] [3] [1221 ] [A-307] [3] [1495] [1] [1729] [A-307] [4] [1495] [1] [1730 ] i需要sql查询那些给我输出的样子： - [SID-1] [SID-3] [1727] [1221] [1729] [1730] b $ b 我该怎么做..

sir, i have a table in which i have data like :-- [RNo.] [SNo.] [CID] [SID] [StuID] [A-307] [1] [1495] [1] [1727] [A-307] [2] [1495] [3] [1221] [A-307] [3] [1495] [1] [1729] [A-307] [4] [1495] [1] [1730] i need a sql query those give me output look like :- [SID-1] [SID-3] [1727] [1221] [1729] [1730] how can i do it..

推荐答案

使用Pivot。 以下链接可以帮助您 在SQL查询中使用Pivot的简单方法 [ ^ ] Use Pivot. Below link may help you Simple Way To Use Pivot In SQL Query[^]