先生,我有一张桌子,其中有数据如下: - [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[^]
更多推荐
在SQL查询中需要帮助..
发布评论