MySQL之分组取最新一条

SELECT v1.* FROM version v1 LEFT JOIN version v2 ON (v1.channel = v2.channel AND v1.id < v2.id) WHERE v2.id is NULL and v1.channel='default'

版权声明:本文为qq_33733970原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。