怎么在mapper.xml中遍历SQL语句

Question

SQL语句是这样的：
SELECT ab.fqzs,ab.mc,ab.zs,CONCAT(ab.bf,'%') bfb FROM(
SELECT aaaa.fqzs,aaaa.mc,aaaa.zs,ROUND(fqzs/zs*100,2) bf FROM(
SELECT aaa.fqzs,aaa.mc,SUM(fqzs) zs FROM
(SELECT COUNT(*) fqzs,aa.mc FROM
(SELECT a.jjsj,a.bar_name,b.bm,SUBSTR(b.mc FROM 7 FOR 2 ) mc FROM fzzx_jjd a JOIN pt_pcs b on a.dw=b.id
WHERE YEAR(a.jjsj)=YEAR(NOW())
)aa
GROUP BY aa.mc
)aaa)aaaa
)ab
这样只能取一个值如下图，我想要遍历这个SQL该怎么遍历？求大神指点

Answer 1

  <select id="methodName" resultMap="ResultMapName">
    <foreach collection="ListName" index="index" separator=";">
      SQL 
    </foreach>
  </select>