1. <legend id='knfzn'><style id='knfzn'><dir id='knfzn'><q id='knfzn'></q></dir></style></legend>
      1. <small id='knfzn'></small><noframes id='knfzn'>

        <i id='knfzn'><tr id='knfzn'><dt id='knfzn'><q id='knfzn'><span id='knfzn'><b id='knfzn'><form id='knfzn'><ins id='knfzn'></ins><ul id='knfzn'></ul><sub id='knfzn'></sub></form><legend id='knfzn'></legend><bdo id='knfzn'><pre id='knfzn'><center id='knfzn'></center></pre></bdo></b><th id='knfzn'></th></span></q></dt></tr></i><div id='knfzn'><tfoot id='knfzn'></tfoot><dl id='knfzn'><fieldset id='knfzn'></fieldset></dl></div>
      2. <tfoot id='knfzn'></tfoot>
          <bdo id='knfzn'></bdo><ul id='knfzn'></ul>

      3. 使用列名逆透视

        时间:2023-07-18

            <tbody id='vpfTm'></tbody>
        1. <i id='vpfTm'><tr id='vpfTm'><dt id='vpfTm'><q id='vpfTm'><span id='vpfTm'><b id='vpfTm'><form id='vpfTm'><ins id='vpfTm'></ins><ul id='vpfTm'></ul><sub id='vpfTm'></sub></form><legend id='vpfTm'></legend><bdo id='vpfTm'><pre id='vpfTm'><center id='vpfTm'></center></pre></bdo></b><th id='vpfTm'></th></span></q></dt></tr></i><div id='vpfTm'><tfoot id='vpfTm'></tfoot><dl id='vpfTm'><fieldset id='vpfTm'></fieldset></dl></div>
          <legend id='vpfTm'><style id='vpfTm'><dir id='vpfTm'><q id='vpfTm'></q></dir></style></legend>

          <tfoot id='vpfTm'></tfoot>

              • <bdo id='vpfTm'></bdo><ul id='vpfTm'></ul>

                <small id='vpfTm'></small><noframes id='vpfTm'>

                  本文介绍了使用列名逆透视的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  我有一个表 StudentMarks,其中包含 Name、Maths、Science、English 列.数据就像

                  I have a table StudentMarks with columns Name, Maths, Science, English. Data is like

                  Name,  Maths, Science, English  
                  Tilak, 90,    40,      60  
                  Raj,   30,    20,      10
                  

                  我想按如下方式安排:

                  Name,  Subject,  Marks
                  Tilak, Maths,    90
                  Tilak, Science,  40
                  Tilak, English,  60
                  

                  使用 unpivot 我是能够正确获取Name、Marks,但无法将源表中的列名获取到所需结果集中的Subject列.

                  With unpivot I am able to get Name, Marks properly, but not able to get the column name in the source table to the Subject column in the desired result set.

                  我怎样才能做到这一点?

                  How can I achieve this?

                  到目前为止,我已经完成了以下查询(以获取名称、标记)

                  I have so far reached the following query (to get Name, Marks)

                  select Name, Marks from studentmarks
                  Unpivot
                  (
                    Marks for details in (Maths, Science, English)
                  
                  ) as UnPvt
                  

                  推荐答案

                  您的查询非常接近.您应该能够使用以下内容,其中包括最终选择列表中的 subject:

                  Your query is very close. You should be able to use the following which includes the subject in the final select list:

                  select u.name, u.subject, u.marks
                  from student s
                  unpivot
                  (
                    marks
                    for subject in (Maths, Science, English)
                  ) u;
                  

                  参见SQL Fiddle with demo

                  这篇关于使用列名逆透视的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  上一篇:为每个类别选择前 10 条记录 下一篇:内连接 vs Where

                  相关文章

                    <bdo id='yLHqr'></bdo><ul id='yLHqr'></ul>
                  1. <small id='yLHqr'></small><noframes id='yLHqr'>

                    1. <i id='yLHqr'><tr id='yLHqr'><dt id='yLHqr'><q id='yLHqr'><span id='yLHqr'><b id='yLHqr'><form id='yLHqr'><ins id='yLHqr'></ins><ul id='yLHqr'></ul><sub id='yLHqr'></sub></form><legend id='yLHqr'></legend><bdo id='yLHqr'><pre id='yLHqr'><center id='yLHqr'></center></pre></bdo></b><th id='yLHqr'></th></span></q></dt></tr></i><div id='yLHqr'><tfoot id='yLHqr'></tfoot><dl id='yLHqr'><fieldset id='yLHqr'></fieldset></dl></div>
                      <legend id='yLHqr'><style id='yLHqr'><dir id='yLHqr'><q id='yLHqr'></q></dir></style></legend>
                      <tfoot id='yLHqr'></tfoot>