Therefore, if you still can’t understand after reading this article, it’s normal. The result is still hard to understand through examples, other people’s blogs and thinking. For example, I started reading many blogs and didn’t understand the usage of pivot. But then again, the way of personal understanding is also different. The above is my understanding of pivot, and I try my best to express it. Now let’s analyze pivot syntax in combination with comments (before that, it’s best to take a look at my blog mentioned above:, the three steps of pivot syntax mentioned in it are very important):
Here is the value of the original week column “Monday”, “Tuesday” Column names are made on “Sunday”, and another work we need to do is to calculate the values of these columns (the “calculation” here is actually the aggregation function (sum, AVG, etc.) in pivot) 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.
Critical ops apk 0.9.1.f113 how to#
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: