![]() In other words, after the row is converted to column, the value of the original column becomes the column name. Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday The query results under normal circumstances are as follows:Īfter the row is transferred to the column, it is as follows: To understand pivot syntax, we need to know why Microsoft designed pivot in this way, but I believe it is the actual needs that give birth to the design ideas, so in the final analysis, we still need to find out what is “row to column”: There is a blog post on the Internet that explains very well: Basically, what I want to write is to refer to the blog and add some personal understanding. So Google has a lot of information, as well as through the above-mentioned week_ The example of income table is tested, and its usage is finally clarified. I don’t know the meaning of pin VOT, but I don’t know how to use it in MSDT. Please refer to the usage of pivot in MSDN:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |