我尝试了两个查询，但它不工作，请帮助我。我多次尝试不输出 [英] i tried both the query but it is not working please help me. i tried lot of times not getting output

问题描述

date	        sess    code   course
14-Jan-13	 1	CM	AFF
14-Jan-13	 3	CM	AFF
17-Jan-13	 1	NR	CTF

从上面我希望输出如下;

from the above i want the output as follows;

                   AFF (course)
         1   2    3   4  (sess)
14-Jan-13    CM      CM

                   CTF     (course)
        1    2  3  4   (sess)
17-Jan-13   NR

获得以上输出我尝试了如下查询;但输出没有得到;

查询如下;

for getting a above output i tried the query as follows; but output is not getting;
query as follows;

SELECT *
FROM (
SELECT *
FROM [Tb_SCh_TIme_Table])
PIVOT(MAX([faculty_code])FOR [session] IN ([1],[2],[3] ,[4])) AS PVT

i在上次运行时显示错误如上所述累了上述查询;

i tired the above query when i run shows error as follows;

Line 5: Incorrect syntax near '('.

附近的语法不正确我的上述查询有什么错误请帮忙我。





添加了代码块（不是原来的缩进使它更清晰） - OriginalGriff [/ edit]

from my above query what is the mistake please help me.


[edit]Code block added (not that the original indentation makes it a lot clearer) - OriginalGriff[/edit]

推荐答案

这是您第三次发布同样的问题（请参阅我想秘密分享课程在c sharp.com中的datagridview中报告 [ ^ ]）。如果您有额外的信息要显示，请不要重新发布相同的问题，但要编辑您的原件。

This is the third time you have posted this same question (see I want to secreate course wise report in datagridview in c sharp .net.[^]). Please do not repost the same issue but edit your original if you have extra information to show.

这篇关于我尝试了两个查询，但它不工作，请帮助我。我多次尝试不输出的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！