一、行转列查询
行转列查询:同一行数据转换为同一列数据;使用联合合并方案【union】
原表:
SELECT t1.responsibility_name, t1.a_hour, t2.b_hour
FROM (SELECT responsibility_name, responsibility_man, SUM(use_hour) a_hour
FROM man_work_list WHERE doc_no='AA00261988'
GROUP BY responsibility_name) t1
JOIN (SELECT responsibility_name, responsibility_man, SUM(use_hour) b_hour
FROM man_work_list WHERE doc_no='AA00262267'
GROUP BY responsibility_name) t2
on t1.responsibility_man=t2.responsibility_man;
行转列查询后的结果:
SELECT responsibility_name, myno, a_hour 'hour'
FROM (SELECT t1.responsibility_name, 'a' AS myno, t1.a_hour
FROM (SELECT responsibility_name