SQL语句：查询数据库mac_vod表中五组具有相同vod_name和vod_year的多条数据每一组都有相同的vod_name和vod_year一条以上构成一组按vod_year升序排列

SELECT vod_name, vod_year, COUNT() FROM mac_vod GROUP BY vod_name, vod_year HAVING COUNT() >= 2 ORDER BY vod_year ASC

原文地址: https://www.cveoy.top/t/topic/iAsv 著作权归作者所有。请勿转载和采集!