mysql分组之后查询的结果集是什么类型? 20
<selectid="count"parameterType="string"resultType="?">selectfilm_typefilmType,COUNT(f...
<select id="count" parameterType="string" resultType="?"> select film_type filmType, COUNT(film_type) count from test_film <where> del_flag='0' <if test="filmType!=null and filmType!='' "> and film_type=#{filmType} </if> </where> GROUP BY film_type </select>
展开
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询