mysql存储过程返回的结果集的问题

mysql存储过程返回的结果集的问题

DELIMITER $$USE `crj`$$DROP PROCEDURE IF EXISTS `crj_duty`$$CREATE DEFINER=`root`@`%` PROCEDURE `crj_duty`()BEGINSET @EE='';SELECT @EE :=CONCAT(@EE,'max(if(duty_type= \'',duty_type,'\',duty_name,NULL)) as ',duty_type, ',') AS aa FROM (SELECT DISTINCT duty_type FROM sks_duty_info) A ;SET @QQ = CONCAT('select ifnull(c.parent_id,\'TOTAL\')as parent_id,',@EE,' b.duty_time from sks_duty_info c,sks_duty_days b WHERE c.parent_id=b.id group by parent_id order by b.duty_time asc');-- SELECT @QQ;PREPARE zbb FROM @QQ;EXECUTE zbb;DEALLOCATE PREPARE zbb;END$$DELIMITER ;**执行结果**![img](https://img-mid.csdnimg.cn/release/static/image/mid/ask/217062378756119.png "#left")![img](https://img-mid.csdnimg.cn/release/static/image/mid/ask/100072378756194.png "#left")**期望结果**我只想要第二个结果集，我该如何处理？