表kaoqin是这样的
[img]http://dl.iteye.com/upload/attachment/259691/0cc08b24-7e20-3246-a399-ccceccaae066.bmp[/img]
我想通过行转列得出下面这样的结果
etimattendancelistid 上午上班 下午上班
0030 旷工 迟到
0061 旷工 旷工
该怎么写,用mysql数据库的
我用
select etimattendancelistid,
sum(case when etimkaoqinfanwei='上午上班' then etimkaoqinzhuangtai end) As '上午上班',
sum(case when etimkaoqinfanwei='下午上班' then etimkaoqinzhuangtai end) As '下午上班'
From kaoqin By etimattendancelistid
结果出现这种状况
[img]http://dl.iteye.com/upload/attachment/259707/9d1f454d-8a78-3b50-939c-bfbe3b9494c2.bmp[/img]
后面用了
select etimattendancelistid,
concat(case when etimkaoqinfanwei='上午上班' then etimkaoqinzhuangtai end) As '上午上班',
concat(case when etimkaoqinfanwei='下午上班' then etimkaoqinzhuangtai end) As '下午上班'
From kaoqin By etimattendancelistid
[img]http://dl.iteye.com/upload/attachment/259714/883e8df7-ada9-39a7-a4a5-3468e8ca23d4.bmp[/img]
结果还是不能满足!
请问大家怎么写查询语句?
[img]http://dl.iteye.com/upload/attachment/259691/0cc08b24-7e20-3246-a399-ccceccaae066.bmp[/img]
我想通过行转列得出下面这样的结果
etimattendancelistid 上午上班 下午上班
0030 旷工 迟到
0061 旷工 旷工
该怎么写,用mysql数据库的
我用
select etimattendancelistid,
sum(case when etimkaoqinfanwei='上午上班' then etimkaoqinzhuangtai end) As '上午上班',
sum(case when etimkaoqinfanwei='下午上班' then etimkaoqinzhuangtai end) As '下午上班'
From kaoqin By etimattendancelistid
结果出现这种状况
[img]http://dl.iteye.com/upload/attachment/259707/9d1f454d-8a78-3b50-939c-bfbe3b9494c2.bmp[/img]
后面用了
select etimattendancelistid,
concat(case when etimkaoqinfanwei='上午上班' then etimkaoqinzhuangtai end) As '上午上班',
concat(case when etimkaoqinfanwei='下午上班' then etimkaoqinzhuangtai end) As '下午上班'
From kaoqin By etimattendancelistid
[img]http://dl.iteye.com/upload/attachment/259714/883e8df7-ada9-39a7-a4a5-3468e8ca23d4.bmp[/img]
结果还是不能满足!
请问大家怎么写查询语句?