1、使用Navicat查询:
select b.data_type,b.field_id,count(1) num from BSINERR b GROUP BY b.field_id,b.data_type;
结果为:
2、mybatis的mappe:
<select id="countByFieldId" resultMap="byFiledId"> select b.data_type,b.field_id,count(1) num from BSINERR b GROUP BY b.field_id,b.data_type </select>
<resultMap id="byFiledId" type="java.util.Map"> <result column="DATA_TYPE" property="dataType" jdbcType="VARCHAR" /> <result column="FIELD_ID" property="fieldId" jdbcType="VARCHAR" /> <result column="count(1)" property="num" jdbcType="VARCHAR"/> </resultMap>
3、Dao用List<Map>接收
List<Map> countByFieldId();
运行结果为:
{NUM=1, dataType=D2, fieldId=pid} {NUM=1, dataType=C1, fieldId=name} {NUM=2, dataType=C1, fieldId=pid}