Create Table |
CREATE TABLE `testtime` ( `id` int(11) NOT NULL AUTO_INCREMENT, `refid` char(6) NOT NULL, `typecode` varchar(6) DEFAULT NULL, `createtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
SELECT refid, MAX(CASE `typecode` WHEN 000001 THEN `createtime` ELSE NULL END ) "创建时间" ,
MAX(CASE `typecode` WHEN 000002 THEN `createtime` ELSE NULL END ) "调度时间"
FROM `testtime`
WHERE `refid`='111111'