distinct order by

好句共享

select distinct tv_id,max(created) as c from ep2tvs group by tv_id order by c desc
原文地址:https://www.cnblogs.com/nasdaqhe/p/950836.html