<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.jeecg.modules.fbsRdrecord32.mapper.FbsRdrecords32Mapper">

    <select id="getMonthSend" resultType="java.util.HashMap">

    select top 5 c.cInvCName,sum(a.iQuantity) iQuantity from rdrecords32 a
        left join rdrecord32 d on a.id = d.id
        left join Inventory b on b.cInvCode = a.cInvCode
        left join InventoryClass c on b.cInvCCode = c.cInvCCode
     where CONVERT(varchar(7),d.dDate,120) like CONVERT(varchar(7),getdate(),120)
	  GROUP BY c.cInvCName

    </select>

</mapper>