在SQL查询中需要帮助.. [英] need help in sql query..

问题描述

先生，我有一张桌子，其中有数据如下： -



[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]

< br $> 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查询中需要帮助..的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！