作者热门文章
- html - 出于某种原因,IE8 对我的 Sass 文件中继承的 html5 CSS 不友好?
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景?
我想将所有具有不同值的列放在右侧。谢谢。
(Column name as follows)
ID
Course
Year Level
Birthdate
Academic ID
Academic Year
Subject
Units
Grade
1900000 | BSIS | 1st Year | 1997-10-08 | 2019-2020-1st Semester | MATH | 3 | 2.0
1900000 | BSIS | 1st Year | 1997-10-08 | 2018-2019-1st Semester | ENG 1 | 3 | 2.1
1900000 | BSIS | 1st Year | 1997-10-08 | 2019-2020-1st Semester | FIL 1 | 3 | 2.0
1900000 | BSIS | 1st Year | 1997-10-08 | 2019-2020-2nd Semester | FIL 1 | 3 | 3.0
1900000 | BSIS | 1st Year | 1997-10-08 | 2018-2019-1st Semester | FIL 1 | 3 | 2.0
尽我所能。拿不到。
输出:到一行(2019-2020-第一学期)
(Column name as follows)
ID
Course
Year Level
Birthdate
Academic ID
Academic Year
Subject
Units
Grade
Subject2
Units
Grade
Subject3
Units
Grade
.......
1900000 | BSIS | 1st Year | 1997-10-08 | 2019-2020-1st Semester | MATH | 3 | 2.0 | MATH | 3 | 2.0 | ENG 1 | 3 | 2.0 | FIL 1 | 3 | 2.0 |
最佳答案
这应该是直截了当的,不需要动态列和旋转,因为主题很少。
- select unique ID using
distinct()
keyword.join
eachsubjects
based onID
select t1.ID, t1.Course, t1."Year Level", t1.Birthdate, t1."Academic ID", t1."Academic Year"
,m.Subject, m.Units, m.Grade
,e.Subject, e.Units, e.Grade
,e.Subject, e.Units, e.Grade
from
(select distinct ID, Course, "Year Level", Birthdate, "Academic ID", "Academic Year" from tableA) as t1
left join tableA m on Subject = 'MATH' and m.ID = t1.ID
left join tableA e on Subject = 'ENG 1' and e.ID = t1.ID
left join tableA f on Subject = 'FIL 1' and f.ID = t1.ID
关于mysql - "How to query this in mysql? I am getting nowhere.",我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/58386964/
我是一名优秀的程序员,十分优秀!