数据透视查询中的错误是什么 [英] what is the error in the pivot query

问题描述

嗨朋友们，



以下是我的数据透视表查询。

Hi friends,

The following is my pivot table query.

select * from (select StudnetAdmissionNumber,23011 as Tamil,23012 as English,2013 as Maths,2014 as Science,2015 as SocialScience from Mark_details)x pivot (max(MarkObtained) for SubjectId in (''23011'',''23012'',''23013'',''23014'',''23015''))p

和错误是'

and the error is

Incorrect syntax near ''23011''.

subjectId数据类型是varchar（30）



有什么问题？

subjectId datatype is varchar(30)

what is the problem?

推荐答案

试试这样。

Hi,

Try like this.

select * from (select StudnetAdmissionNumber,
			23011 as Tamil,
                        23012 as English,
                        2013 as Maths,
                        2014 as Science,
                        2015 as SocialScience 
                        from Mark_details) x 
                        pivot (max(MarkObtained) for SubjectId in (''23011'',''23012'',''23013'',''23014'',''23015'')) AS p

谢谢

Thanks

这篇关于数据透视查询中的错误是什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！