您需要一些键来定义3行的集合。然后，您就可以自我加入
所以对于这样的数据…
ID | GroupID | Group_Level | Group_Values1 | 1 | Division | Value 12 | 1 | Department | Value 23 | 1 | Class | Value 34 | 2 | Division | Value 15 | 2 | Department | Value 26 | 2 | Class | Value 3
你会
SELECt Div.GroupID, Div.Group_Values, Dept.Group_Values, Cl.Group_ValuesFROM MyTable Div JOIN MyTable Dept ON Div.GroupID = Dept.GroupID JOIN MyTable Cl ON Div.GroupID = Cl.GroupIDWHERe Div.Group_Level = 'Division' AND Dept.Group_Level = 'Department' AND Cl.Group_Level = 'Class'
