<select id="selectLists" resultType="map">
select
a.STARTDATE AS "startTime",
a.CHANNELID AS "channelId",
count(a.PROGRAMNAME) AS "programNum",
b.CHANNELNAME AS "channelName",
b.CHANNELNUMBER AS "channelNumber"
from
CMS_SCHEDULE a,CMS_CHANNEL b
where a.CHANNELID=b.CHANNELID
<if test="channelId != null and channelId != ''">
and a.CHANNELID like CONCAT(CONCAT('%',#{channelId}),'%')
</if>
group by a.CHANNELID,a.STARTDATE,b.CHANNELNAME,b.CHANNELNUMBER
order by a.STARTDATE desc
</select>
oracle,要统计一个表里,每个频道,每天有多少个节目并排序
最新推荐文章于 2021-04-11 17:17:23 发布